Can I reverse graph?

[cdpaul]

Hi,

I managed to make myself a graph that shows each month (Jan18, Feb18, Mar18 etc) but can I change it so the months are reversed? ie the latest month is on the left hand side.
I tried to change the order of the data to newest to oldest but it doesn't change on the graph.

Hope that makes sense.

Thank you

 

[Yongle]

Try this

Click on the Axis in the chart to select it \ right-click \ Format Axis \ (Under Axis Option) check Categories in Reverse Order

 

[cdpaul]

Thank you. This almost works in that it reverses the dates as I would like but it also moves the values to the right as well. I don't know the correct terminology so in way of explanation of what I mean: In my original graph the left hand side vertical axis has -£, £0, +£ values and these are what are also moving when I follow yr instructions.

Hopefully I'm making some sense

 

[Yongle]

Have forgotten your maths lessons?
- I think you want to move the y-axis back to the left side of the chart

Same place as before - find the setting for "Vertical axis crosses" and set to "At maximum date"

 

[cdpaul]

Fantastic!

Thank you so much