Excel chart: How to reverse the X axis of time series data
- by JohnnyLambada
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
…