Forum Discussion
How to change the orientation of all chart column labels simultaneously?
- Jul 31, 2022
Jitterbug23 Please don't be impatient!
A trick you could is this. Create a chart with only one of the series. Add the labels and set the rotation as you desire. Select the entire chart you just created. Ctrl-C. Select the chart that contains all the series and remove all data labels. On the Home ribbon, press Paste, Paste Special..., Formats. The chart should now have labels in the same orientation for all series.
An alternative would be to start with a one series and once you have formatted the labels, add the other series. They will have labels with the orientation.
Edit: This seems to work on Mac only. Don't really know why.
Edit 2: On both Windows and Mac, you can format the first series labels, then select the next and press F4. Repeat for all others. Still some work but you don't have to click through all the steps for each and every one.
dont all answer at once,
no I dont think its possible, a little microsoft oversight. Who would want to align all their labels across 100 bars at the same time, nah do it manually because you dont have the time.