Show All

Reverse the plotting order of categories, values, or series

You can reverse the plotting order of categories or values for most charts, as well as of data series for 3-D charts with a third axis. You cannot reverse the plotting order of values in a radar chart.

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