Place a check mark into the box next to 'Categories in reverse order' to flip the order of the categories on the chart. Note that this will cause the labels on the other axis to shift to the other.

Wunderlist mac download free. 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 . 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. • Click the axis for the categories, values, or series whose plotting order you want to change. • On the Format menu, click Selected Axis, and then click the Scale tab.

Note Selected Axis is only available on the Format menu when a data series is selected. • To reverse the plotting order, do one of the following: • For categories, select the Categories in reverse order check box. • For values, select the Values in reverse order check box. • For series in 3-D charts, select the Series in reverse order check box. SJohnny, similar to you, I had some financial data displayed with dates on the Y axis, and I had the same problem; the line graph I created initially was backward. However, without using an XY graph, there's a simple way of fixing the chronological order of the data. • Select the data you want to graph.

• Using the graph function (Chart Wizard), select a line graph. • At step 3 of 4, under 'primary axis,' select 'Time Scale.'

This should immediately correct the order for preview before you finsh creating the graph.