I currently have my chart set up like so :

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.

3 Answers

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.

2

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.

To keep the Y axis in the same place go to Format Axis>Axis Options>Labels and change label position to "Next to Axis"

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy