Change order of columns in graph

[ammartino44]

Hello. I have a column chart in excel. How can I change the order of the columns (left to right)?

[ammartino44]

I found categories in reverse orders but that changes the vertical scale to the right side. Why does it do that? I want the scale on the left side.

[Andy Pope]

Because the axis normal starts next to the first value.
You also need to set Vertical axis crosses at Maximum for the axis

[ammartino44]

How do I change it to the left side? And what do you mean set vertical axis crosses at maximum?

[Andy Pope]

1076217.png

Set both properties for the horizontal axis