Forum Discussion

UserXL's avatar
UserXL
Copper Contributor
Nov 15, 2022

Limitation of the number of characters when referring to a cell

Hi there,   In a donut chart, I want to customize the data labels by displaying values ​​from other cells in the same sheet (=> refer to a range of data labels from the "Label Format" pane). I spec...
excel
office 365
tauqeeracma's avatar
tauqeeracma
Iron Contributor
Nov 21, 2022

Hi. UserXL 

 

I don't think that there is any limit applied to the size of the data labels. For more understanding purposes, I attach a sample file wherein I have added a donut chart with customized labels of different sizes. All values are fully displayed (without truncated)

 

 

 

It would be appropriate if you attach some sample data so a better solution can be suggested.

 

Thanks

Tauqeer

  • UserXL's avatar
    UserXL
    Copper Contributor
    Nov 23, 2022

    tauqeeracma 

     

    Hello Tauqeer,

     

    I got my answer on another forum and indeed the number of characters in the data labels is limited to 256. Unfortunately in my case, this limit prevents me from displaying the information I want and I will have to do otherwise .

    Thank you for your help.

     

    Regards,

     

    UserXL

Resources