How can I change the order of column chart in excel?

%3CLINGO-SUB%20id%3D%22lingo-sub-1777298%22%20slang%3D%22en-US%22%3EHow%20can%20I%20change%20the%20order%20of%20column%20chart%20in%20excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1777298%22%20slang%3D%22en-US%22%3E%3CP%3EI%20created%20a%20table%20and%20chart%2C%20but%20the%20order%20in%20the%20chart%20starts%20from%20%22E%22%20instead%20of%20%22A%22.%20I%20want%20the%20chart%20to%20start%20from%20A%20down%20to%20E.%20instead%20of%20E%20on%20the%20top%20and%20A%20on%20the%20bottom.%20Please%20advise%20how%20I%20can%20do%20that.%20Thank%20you%20so%20much%20for%20reading%20my%20question.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20attached%20a%20screenshot.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1777298%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1777343%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20change%20the%20order%20of%20column%20chart%20in%20excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1777343%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F830942%22%20target%3D%22_blank%22%3E%40excelforjeff%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDouble-click%20any%20of%20the%20category%20axis%20(y-axis)%20labels.%3C%2FP%3E%0A%3CP%3ETick%20the%20check%20box%20'Categories%20in%20reverse%20order'%20in%20the%20'Format%20Axis'%20task%20pane.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S3571.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F226463i00EAA38E258194F0%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22S3571.png%22%20alt%3D%22S3571.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1777350%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20change%20the%20order%20of%20column%20chart%20in%20excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1777350%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3BThanks%20a%20lot!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20happen%20to%20know%20if%20there%20is%20a%20similar%20setting%20for%20office%20for%20Mac%3F%20I%20looked%20in%20the%20%3CSPAN%3Eaxis%20property%20section%20but%20coudnt%20find%20one...%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

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 can do that. Thank you so much for reading my question. 

 

I've attached a screenshot. 

6 Replies
Highlighted

@excelforjeff 

Double-click any of the category axis (y-axis) labels.

Tick the check box 'Categories in reverse order' in the 'Format Axis' task pane.

 

S3571.png

Highlighted

@Hans Vogelaar 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...

Highlighted

I found this setting, but not reversing the orders...

 

Highlighted

@excelforjeff 

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.

Highlighted

@Hans Vogelaar I'm sorry where would that be..?

>double-click the vertical axis

 

 

Highlighted