Change the plotting order of categories, values, or data series

If the chart for which you want to change the plotting order displays axes (axis: A line bordering the chart plot area used as a frame of reference for measurement. The y axis is usually the vertical axis and contains data. The x-axis is usually the horizontal axis and contains categories.), you can quickly reverse the order in which the categories or values are plotted along those axes. Additionally, in 3-D charts that have a depth axis, you can reverse the plotting order of data series so that large 3-D data markers (data marker: A bar, area, dot, slice, or other symbol in a chart that represents a single data point or value that originates from a worksheet cell. Related data markers in a chart constitute a data series.) do not block smaller ones.

You can also change the order in which the individual data series are plotted in a chart.

What do you want to do?


Reverse the plotting order of categories or values in a chart

  1. On a chart, do one of the following:
    • To change the plotting order of categories, click the horizontal (category) axis.
    • To change the plotting order of values, click the vertical (value) axis.
    • You can also do the following to select the axis that you want from a list of chart elements:
      1. Click a chart.
        This displays the Chart Tools, adding the Design, Layout, and Format tabs.
      2. On the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then click the chart element that you want to use.

Excel Ribbon

  1. On the Format tab, in the Current Selection group, click Format Selection.
  2. In the Axis Options category, 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.

 Note   You cannot reverse the plotting order of values in a radar chart.

Top of Page Top of Page

Reverse the plotting order of data series in a 3-D chart

You can change the plotting order of data series so that large 3-D data markers (data marker: A bar, area, dot, slice, or other symbol in a chart that represents a single data point or value that originates from a worksheet cell. Related data markers in a chart constitute a data series.) do not block smaller ones.


3-D chart displayed in reversed order

3-D charts with data series that are displayed in reversed orders

  1. On a chart, click the depth axis, or do the following to select it from a list of chart elements:
    1. Click a chart.
      This displays the Chart Tools, adding the Design, Layout, and Format tabs.
    2. On the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then click the chart element that you want to use.

Excel Ribbon

  1. On the Format tab, in the Current Selection group, click Format Selection.
  2. In the Axis Options category, under Axis Options, select the Series in reverse order check box.

Top of Page Top of Page

Change the plotting order of data series in a chart

  1. Click the chart for which you want to change the plotting order of data series.

This displays the Chart Tools, adding the Design, Layout, and Format tabs.

  1. On the Design tab, in the Data group, click Select Data.

Excel Ribbon Image

  1. In the Select Data Source dialog box, in the Legend Entries (Series) box, click the data series for which you want to change the order.
  2. Click Move Up or Move Down to move the data series to the position that you want.

Top of Page Top of Page

 
 
Applies to:
Excel 2007, Outlook 2007, PowerPoint 2007, Word 2007