Nov 13 2023 02:28 PM
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
Nov 16 2023 07:07 AM
Solution
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 😞
Nov 23 2023 10:31 PM
You're welcome @anupambit1797 (charts are not my specialty thoug 🙂
Nov 16 2023 07:07 AM
Solution
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 😞