View original (French)

Reverse the chronology of a graph for the x-axis.

Solved
Barlatshi Posted messages 65 Status Membre -  
 valentin -
Hello,

I have a vertical column where the data at the top of the column is the most recent and the data at the bottom of the column is the oldest. I have a bar graph in Excel 2007 that reflects this data.

My problem is that the graph displays the most recent data on the left side of the graph (since it's at the top of my column) and the oldest data on the right side of the graph. I would like the graph to display the data that is at the top of the column on the right side of the graph and the data that is at the bottom of the column on the left side of the graph.

I hope I made myself clear; I can provide more explanations if needed.

Thank you for your responses ;-)

Configuration: Windows 7 / Chrome 27.0.1453.110

2 réponses

Réponse 1 / 2
tontong Posted messages 2575 Registration date   Status Membre Last intervention   1 064
 
Hello,
Right-click on the X-axis -> Axis Format -> Scale tab check Reverse axis order, also check The Y-axis crosses at the maximum abscissa to prevent the Y-axis from appearing on the right.
14
Barlatshi Posted messages 65 Status Membre 5
 
Ok thanks, I’ll check that right away especially for the ordinates!
0
valentin
 
Thank you for these valuable tips!
0
Réponse 2 / 2
Barlatshi Posted messages 65 Status Membre 5
 
I respond that it can be useful,

To invert, you need to select the axis, right-click and choose "Format Axis," then in Axis Options check "Values in reverse order."
6