Forum Discussion
Solved
How to drag the data labels to a place far from bar
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 😞
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
Not exactly what you wanted to do but at least %ages can be read on don't overlap (pic. cropped):
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 😞
3 Replies
Not exactly what you wanted to do but at least %ages can be read on don't overlap (pic. cropped):
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 😞
Thank youLorenzo !!
You're welcome anupambit1797 (charts are not my specialty thoug 🙂
