SOLVED

How to drag the data labels to a place far from bar

Iron Contributor

Dear Experts,

                   Need a help, how to select the data in below chart and drag to a bit far from bars so that the data don't overlap each other , I tried to do ctrl + drag, but only one data was selected 😞

 

anupambit1797_0-1699914429751.png

Like in this Data values are not readable , so want to drag them a bit away from the congested area.

Attaching the spread sheet.

 

Thanks & Regards

Anupam Shrivastava

3 Replies
best response confirmed by anupambit1797 (Iron Contributor)
Solution

Hi @anupambit1797 

 

Not exactly what you wanted to do but at least %ages can be read on don't overlap (pic. cropped):

 

Sample.png

 

Right-click on a Serie (i.e. the Orange bar) > Format Data Series... > Click on a label (a %age) > Alignment > Text direction: Rotate all text 270°

 

Obviously this needs to be done 1 Serie at a time 😞

You're welcome @anupambit1797 (charts are not my specialty thoug 🙂

1 best response

Accepted Solutions
best response confirmed by anupambit1797 (Iron Contributor)
Solution

Hi @anupambit1797 

 

Not exactly what you wanted to do but at least %ages can be read on don't overlap (pic. cropped):

 

Sample.png

 

Right-click on a Serie (i.e. the Orange bar) > Format Data Series... > Click on a label (a %age) > Alignment > Text direction: Rotate all text 270°

 

Obviously this needs to be done 1 Serie at a time 😞

View solution in original post