PowerPoint Chart Legend Reorder: How to Move Series Without Editing Data

When you add a chart to a PowerPoint slide, the legend displays the data series in the order they appear in the source data. If you want the legend to show a different sequence, you may think you must edit the Excel worksheet behind the chart. The legend order and the series drawing order are controlled by the chart’s internal series collection, which you can rearrange directly inside PowerPoint. This article explains how to move chart series up or down in the legend without touching the underlying data.

Why the Legend Order Is Tied to the Series Collection

Every PowerPoint chart contains a series collection — a list of all data series shown on the chart. The order of this list determines both the legend entry order and the drawing order of the chart elements (columns, lines, pie slices). By default, the collection mirrors the column or row order in the chart’s source data. When you add a new series to the chart by editing the data range, the series is appended to the end of the collection.

PowerPoint does not provide a direct “reorder legend” button. Instead, you must change the series position within the series collection. This action updates the legend automatically. The methods below work with bar charts, column charts, line charts, pie charts, and most other chart types. For pie charts, the legend order also affects the order of the slices.

Method 1: Use the Selection Pane to Move a Series Up or Down

The Selection Pane lists every element on the slide, including chart series. You can drag or use the reorder arrows to change the series position.

1. Select the chart on the slide
   Click the chart once to activate the Chart Tools contextual tabs on the ribbon.
2. Open the Selection Pane
   Go to Chart Tools > Format > Selection Pane. The pane opens on the right side of the PowerPoint window.
3. Locate the series you want to move
   In the Selection Pane, each series appears with its name (for example, “Series 1” or “Sales Q1”). The list also includes the chart area and plot area.
4. Click the series name to select it
   A single click highlights the series in the pane and selects it on the chart.
5. Use the up or down arrow button at the top of the pane
   Click the up arrow to move the series earlier in the legend. Click the down arrow to move it later. The legend updates immediately.
6. Repeat for each series you need to reorder
   Continue until the legend displays the sequence you want.

Method 2: Reorder Series Through the Select Data Dialog

The Select Data dialog provides a dedicated list of legend entries with up and down arrow buttons. This method is available in PowerPoint 2013 and later versions.

1. Right-click the chart
   Choose Select Data from the context menu. The Select Data Source dialog opens.
2. Look at the Legend Entries (Series) list on the left side
   Each series name appears in a vertical list. The top entry is the first series in the legend.
3. Click a series name to select it
   The series becomes highlighted. The up and down arrow buttons above the list become active.
4. Click the up or down arrow to move the series
   Each click shifts the series one position. The chart preview on the right side of the dialog updates to show the new order.
5. Click OK to apply the change
   The dialog closes and the legend reflects the new series order.

Method 3: Move Series With a VBA Macro

If you need to reorder series in multiple charts or on many slides, a VBA macro saves time. The macro below moves a specific series to a new position in the series collection.

1. Open the VBA editor
   Press Alt + F11 on your keyboard.
2. Insert a new module
   In the editor, go to Insert > Module.
3. Paste the following code into the module

   Sub MoveChartSeries()
       Dim cht As Chart
       Dim srs As Series
       Dim idx As Integer
       
       ' Select the chart first
       If ActiveWindow.Selection.Type = ppSelectionShapes Then
           If ActiveWindow.Selection.ShapeRange(1).HasChart Then
               Set cht = ActiveWindow.Selection.ShapeRange(1).Chart
           Else
               MsgBox "Selected shape does not contain a chart."
               Exit Sub
           End If
       Else
           MsgBox "Select a chart first."
           Exit Sub
       End If
       
       ' Move the last series to position 1 (first in legend)
       idx = cht.SeriesCollection.Count
       cht.SeriesCollection(idx).PlotOrder = 1
   End Sub

4. Edit the macro to match your needs
   Change the line cht.SeriesCollection(idx).PlotOrder = 1 to set a different target position. For example, PlotOrder = 2 moves the series to the second position.
5. Run the macro
   Close the editor, select a chart on a slide, then press Alt + F8. Choose MoveChartSeries and click Run.

Common Issues When Reordering the Chart Legend

The legend does not change after using the Selection Pane

The Selection Pane reorders the drawing order of the chart elements, but it does not always update the legend for all chart types. If you move a series in the Selection Pane and the legend stays the same, use the Select Data dialog instead. This dialog directly modifies the series collection, which controls the legend.

The up and down arrows are grayed out in the Select Data dialog

This happens when the chart is linked to an Excel worksheet that is not currently open. Close the dialog, open the linked workbook, and try again. If the chart uses a fixed data range embedded in the PowerPoint file, the arrows should be active.

Pie chart slices do not reorder when you move the legend entry

In pie charts, the legend order and the slice order are linked to the series collection. However, the slices also follow a clockwise default order starting from the top. To change both the legend and slice order, you must reorder the data in the source range. Alternatively, you can rotate the pie chart by right-clicking a slice, choosing Format Data Series, and adjusting the Angle of first slice setting.

PowerPoint Chart Legend Reordering Methods Compared

Item	Selection Pane Method	Select Data Dialog Method	VBA Macro Method
Ease of use	Fast for one or two series	Requires opening a dialog	Requires basic VBA knowledge
Works with all chart types	Yes, but legend may not update for some types	Yes, for bar, column, line, pie	Yes, all chart types supported
Changes source data	No	No	No
Best for	Quick visual reorder	Precise legend control	Batch reorder on many charts

You can now reorder any chart legend in PowerPoint by moving series up or down using the Selection Pane, the Select Data dialog, or a VBA macro. The legend updates instantly without altering the Excel data behind the chart. Try combining the Select Data dialog with the Format Legend pane to also change the legend position and font size for a polished presentation.