13
3
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.
4Beautiful -- thank you so much! One more thing. When I checked "Categories in reverse order", the values of the Y axis moved to the right side. I had to check "Value (Y) axis crosses at maximum catetory" as well to get the Y axis values to appear on the left where they belong. – JohnnyLambada – 2008-10-09T00:05:46.923