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

If the chart for which you want to change the plotting order displays axes, 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 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

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

Change the plotting order of data series in a chart

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 image

  2. On the Format tab, in the Current Selection group, click Format Selection.

  3. 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

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 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 image

  2. On the Format tab, in the Current Selection group, click Format Selection.

  3. In the Axis Options category, under Axis Options, select the Series in reverse order check box.

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.

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

    Excel Ribbon Image

  3. 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.

  4. Click Move Up or Move Down to move the data series to the position that you want.

Top of Page

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



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language