Excel Chart, Reverse X Axis direction with values

I currently have my chart set up like so :

enter image description here

How can I change the order so that it is read from left to right?

Right now it goes from recent date to last date. When I Reverse Categories, it also shifts the Y Axis to the right hand side, I want to keep the Y axis on the left.


You right click on the axis itself, and select format axis, or you can simply double click the axis depending on your version.

Then look for the setting categories in reverse order, click this box.

See image below.

enter image description here


I figured out how to keep the Y axis on the left side, for anyone who stumbles across this on Google. Click the X axis, then format axis, and under Vertical axis crosses, select At maximum category.