Manually Rearrange a Pivot Chart in Excel

Yes. In Excel, manually rearrange a PivotChart by changing the item order in its associated PivotTable: drag a row or column label to a new position, and the chart follows that order. You generally cannot drag a PivotChart bar, column, or point to give it an independent order.

Why the PivotTable Controls the Chart

A PivotChart is linked to a PivotTable, which summarizes and organizes the source data. The chart’s categories and series come from the fields and items in that table. For example, if a PivotTable lists sales regions as East, North, South, West, its chart uses that sequence for the category axis. Moving North above East in the PivotTable changes the chart’s category order too.

This connection is useful because the chart stays in step with the summary when you filter, expand, collapse, or refresh it. The trade-off is that the chart is not an independent drawing: its data order is governed by the PivotTable. Formatting a bar or changing the chart type does not change the underlying item sequence.

Steps to Manually Reorder Categories

Click a cell inside the PivotTable associated with the chart. If you are unsure which table is linked, click the PivotChart and look for its PivotTable connection in the workbook.
Find the category item you want to move. It is usually a label under Row Labels or in a column field, depending on the PivotTable layout.
Click the item’s label cell, not a number in the Values area. Point at the cell’s border until the move cursor appears, then drag the item to the required position among the other items in that field.
Release the mouse button and check both the PivotTable and chart. The chart should update to reflect the new sequence.

For instance, a monthly report might show April, August, December, and October because the labels were sorted alphabetically. Dragging August and October into calendar order makes the PivotChart display the months in the intended sequence. You can also use this approach to put a priority category first or move an “Other” group to the end.

Take care to drag the label itself. Dragging a cell value can select or move something else, and dropping an item in the wrong place can change its order unexpectedly. If Excel will not let you drag an item, use the manual-sort option described below, check whether the PivotTable source permits manual ordering, or try the desktop version of Excel.

Reordering Series in the Legend

A chart’s categories and its series are different things. Categories usually run along the horizontal axis in a column chart, while series are shown in the legend and represented by different colors. In a report with months as categories and product types as series, changing the month order affects the axis; changing the order of product types affects the series order.

To change the order of series items, locate the field that supplies the legend in the PivotChart Fields pane. Its items commonly appear as column labels in the PivotTable. Reorder those item labels there, just as you would reorder categories. If the chart uses a field in the Legend (Series) area, moving the field itself to another area is a different action: it changes how the data is grouped, not just the sequence of series.

After reordering, check the legend as well as the plotted marks. Some chart types make series order especially noticeable: it can affect the sequence of colors and, in stacked charts, which series is drawn closest to the axis. A change in series order does not change the underlying totals, but it can change how readers interpret the display.

Use Manual Sort When Dragging Is Awkward

Excel can expose manual ordering through the PivotTable’s sort options. Right-click an item label and choose Sort > More Sort Options. In the dialog, choose Manual if that option is available, then close the dialog and drag the item to the desired location. The exact menu options depend on the field and the type of data connection.

Automatic sorting is better when the order should be alphabetical or based on a value, such as largest sales first. Manual sorting is better when the order has meaning that is not captured by the label or measure—for example, a sales process that moves from Lead to Qualified to Proposal to Closed. Choose the sorting method that represents the purpose of the report rather than changing the order only to make the chart look different.

Manual order: Use for a custom presentation sequence or a deliberate priority order.
Alphabetical order: Use when readers are looking up labels and a predictable name order is most helpful.
Value-based order: Use when ranking categories by a measure, such as revenue or count.

If a field is arranged by value or another sort rule, Excel may reapply that rule instead of keeping a dragged position. Check the field’s sort options before concluding that the drag failed. For a PivotTable connected to an external or OLAP source, some manual-sorting behavior can be restricted by the source or connection.

What Happens After a Refresh?

A manual order is a setting in the PivotTable, not a rewrite of the source data. Refreshing the PivotTable updates its summarized data from the source, and the chart continues to reflect the PivotTable’s resulting item order. In ordinary workbooks, a manual arrangement is generally retained, but it is worth checking the order after a refresh, especially if new items appear or the data connection imposes its own sorting rules.

New categories do not necessarily land where you would want them in a custom sequence. If a report must always follow a fixed business order, consider whether the source data can include a sequence field, such as StageOrder with 1 for Lead, 2 for Qualified, and so on. A helper field can make the intended order clearer and more repeatable than relying on a one-time drag. The PivotTable still needs to be configured to sort according to that order; adding a helper column alone does not guarantee the chart will use it.

Also distinguish a refresh from changing the data source or rebuilding the PivotTable. Replacing the table, altering field placement, or changing the connection can affect saved layout and sort behavior. For important reports, keep a copy before making structural changes and verify the chart after the next refresh.

Common Problems and Practical Fixes

The chart order does not change: Confirm that you edited the PivotTable linked to that chart, and that you moved a label in the field used for the chart’s categories or series. A workbook can contain several PivotTables and charts.
Dragging will not start: Make sure the pointer is on the item cell’s border and that you are not in cell-edit mode. Try right-clicking the label and opening Sort > More Sort Options to see whether Manual is available.
The item snaps back: An automatic sort, a connection limitation, or an unsupported manual sort can override the move. Review the sort settings and, if the data comes from an external model, check whether that source allows manual ordering.
The chart looks wrong after reordering: Check whether you moved categories or series. In a stacked chart, changing series order changes the stack sequence. In a bar chart, the apparent top-to-bottom order can also depend on the category-axis settings.
The order changes when new data arrives: Newly introduced items need a place in the desired sequence. Use a deliberate sort rule or an order field in the source when the report must follow a repeatable process.

One common misconception is that manually arranging the chart changes the order of rows in the original data. It does not. The source records remain as they were; the PivotTable controls the displayed summary order. Likewise, changing the order does not alter a category’s value or recalculate the source.

When a Regular Chart or Helper Order Is Better

If the exact chart sequence must be independent of the PivotTable, use a normal chart based on a separate, deliberately ordered summary range. A regular chart can be arranged according to that range without relying on PivotChart item ordering. The cost is that the summary range may need its own formulas or updating process, and it will not behave exactly like a PivotChart when users filter fields.

For recurring reports, a source-level order field or a carefully maintained custom sequence is often more robust than repeatedly dragging labels. For a one-off presentation, manual PivotTable ordering is usually simpler. Choose based on whether users need interactive PivotChart filtering or a fixed, publication-ready display.

In Excel for Microsoft 365 on Windows, use the PivotTable’s item labels and sort options as described above. Excel for Mac follows the same basic principle, though ribbon and context-menu details can vary. Excel for the web may not expose every desktop PivotTable control; if the manual option is missing, open the workbook in desktop Excel and make the change there.

Frequently Asked Questions

Can I drag bars directly in an Excel PivotChart?
No. A PivotChart’s item order is controlled by its associated PivotTable. Reorder the category or series labels in that table, and the chart updates to match.

How do I put PivotChart months in calendar order?
Reorder the month items in the associated PivotTable, or use a date field and an appropriate chronological grouping. If the labels are text and sort alphabetically, manual ordering or a source-level month sequence can provide the intended calendar order.

Why does my PivotChart keep returning to alphabetical order?
The field may have an automatic sort rule, or its data connection may restrict manual sorting. Check the field’s sort options and see whether Manual is available. A newly refreshed source or a changed PivotTable layout can also affect the displayed order.

Can I change the legend order without changing the category order?
Yes, when the chart uses separate fields for categories and series. Reorder the items in the field that supplies the legend, usually represented by column labels in the PivotTable, and leave the category field unchanged.

Does manual sorting change the source data?
No. It changes the order of summarized items in the PivotTable and PivotChart, not the order or contents of the original records.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.