Change the Series Order in a Pivot Chart

When you create a pivot chart, the series order is automatically applied. In this example, the product categories had been manually sorted in the pivot table. In the pivot chart legend, the products are in the same order: Crackers, Snacks, Bars and Cookies.

ChartSeries01

In a longer list of items, you might like the series sorted alphabetically, so they’re easier to find in the list.

Change the Sort Order

To change the sort order, follow these steps:

  1. Select the pivot chart
  2. If the PivotChart Filter pane isn’t visible, click the Analyze tab on the Ribbon, then click PivotChart Filter.RibbonPivotChartFilter
  3. In the PivotChart Filter pane, click the arrow in the drop-down list for the field you want to sort. In this example,
    click the arrow for the Legend Fields (series), where the Category field is listed.ChartSeries02
  4. Click Sort A-Z, to sort the categories in ascending order

ChartSeries03

Pivot Table Series Order

NOTE: Changing the series order in the Pivot Chart will also affect the Pivot Table on which it is based.

_________________

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.