Forum Discussion
excelforjeff
Oct 13, 2020Copper Contributor
How can I change the order of column chart in excel?
I created a table and chart, but the order in the chart starts from "E" instead of "A". I want the chart to start from A down to E. instead of E on the top and A on the bottom. Please advise how I ca...
HansVogelaar
Oct 13, 2020MVP
Double-click any of the category axis (y-axis) labels.
Tick the check box 'Categories in reverse order' in the 'Format Axis' task pane.
- excelforjeffOct 13, 2020Copper Contributor
I found this setting, but not reversing the orders...
- HansVogelaarOct 13, 2020MVP
You have reversed the value axis (the horizontal one) instead of the category axis (the vertical one).
If you want to reverse the order of the vertical axis, you should double-click the vertical axis, of course.
- excelforjeffOct 13, 2020Copper Contributor
- excelforjeffOct 13, 2020Copper Contributor
HansVogelaar Thanks a lot!
Do you happen to know if there is a similar setting for office for Mac? I looked in the axis property section but coudnt find one...