Reversing the Order of Categories or Values

You may choose to display the categories or values on an axis in reverse order. This may help emphasize a particular aspect of your chart or it may simply save you from having to edit the chart's data range.

The axis intersection may automatically change when you change the order of the categories or values. In this case, you may have to change the axis intersection to place the axis where you want it.

To reverse the order of categories or values on an axis:

1. Select the axis.
2. Choose Format Axis from the context menu and click the Scale tab.
3. For a value axis, check the Values in reverse order checkbox. For a category axis, check the Categories in reverse order checkbox.
4. Click OK or Apply.