Excel chart: How to reverse the X axis of time series data

Posted by JohnnyLambada on Super User See other posts from Super User or by JohnnyLambada
Published on 2008-10-08T23:51:58Z Indexed on 2014/08/22 4:23 UTC
Read the original article Hit count: 221

Filed under:
|

In Excel 2003, I have a time series from a financial report that goes something like this:

         2007 2006 2005
Amount   300  200  100

I want to create a graph of the time series that looks something like this (please excuse the ugly ascii graph):

300|                .x
   |             ...
200|         .x..
   |      ...
100|    x
   |____________________
  0   2005   2006   2007

But intead of getting an upward sloping graph, excel wants to put my time series in reverse (the way it actually appears in the spreadsheet). Is there any way to make excel display the x axis in reverse of the way it normally does? I've tried manually reversing the range in the chart dialog (changing a range of B1:D3 to D3:B1), but excel just puts it back.

© Super User or respective owner

Related posts about microsoft-excel

Related posts about charts