Manual Sort Pivot Chart in Excel: Control Category Order

To manually sort a PivotChart in Excel for Microsoft 365 on Windows, reorder the chart’s categories in its associated PivotTable: select a row-label item and drag it to the desired position. A PivotChart follows the order of its PivotTable, so changing the chart alone is usually not the way to set a custom sequence.

Why the PivotTable controls the chart

A PivotChart is linked to a PivotTable that summarizes the source data. The table’s row and column fields define the chart’s categories and series, while its value fields supply the plotted numbers. When you rearrange the items in a field, the chart updates to reflect that order. This is useful when the right sequence is not alphabetical or numerical: for example, a sales chart might need to show business stages as Prospect, Qualified, Proposal, Won, rather than alphabetically.

This relationship also explains why a chart can seem resistant to direct editing. A regular chart often lets you rearrange the source data or change its category range. A PivotChart uses PivotTable fields and their item order instead. Its field buttons and filters can change which items are displayed, but they do not provide a separate, independent category sequence.

For a chart with months along the horizontal axis, the months might come from a PivotTable row field. For a chart with product names in the legend, those names might come from a column field. Identify which field supplies the items you want to rearrange before moving anything.

Manually reorder PivotChart categories

Use the PivotTable connected to the chart. If it is not visible, click the PivotChart and look for its linked PivotTable in the workbook, or use the field list to identify the fields used in the chart. The table may be on another worksheet.

Click a cell in the PivotTable field whose items appear as chart categories. For a chart axis, this is commonly a row-label field; for legend entries, it may be a column-label field.
If the field is currently sorted automatically, right-click one of its item labels and choose Sort > More Sort Options. If the dialog offers Manual, choose it. The exact controls can vary slightly with the workbook layout.
Point to the item label you want to move. When the pointer indicates that the item can be dragged, drag the label to the desired position and release it. Move one item at a time if you need a precise sequence.
Check the PivotChart. Its categories or series should follow the updated PivotTable order. If the chart is filtered, some reordered items may not be visible until you change the filter.

For example, suppose a PivotTable lists four support priorities alphabetically as Critical, High, Low, Medium, but a report should present them as Critical, High, Medium, Low. Drag Medium above Low in the priority field. The chart then uses that sequence, making it easier to read in the intended operational order.

Be careful to drag the field item label, not a number in the Values area. Moving a value cell can change or select data rather than reorder a category. If dragging does not work, check that Excel’s drag-and-drop option is enabled under File > Options > Advanced, in the Editing options section. Workbook protection or a layout that merges or groups items can also affect editing.

Choose the right field and order

A PivotChart can have multiple category levels. A chart showing Region and then City, for instance, may use a two-level row field hierarchy. Reordering a Region changes the order of the region groups; reordering cities changes the order within the relevant field. If the chart has many levels, expand or collapse the PivotTable groups as needed to locate the items you want to move.

In a column chart, row-field items commonly form the horizontal categories, while column-field items often form separate series in the legend. In a bar chart, the category axis is vertical, but the underlying PivotTable field still controls the item sequence. If you are unsure which field controls a visual element, click the chart and inspect the PivotChart Fields pane. The Rows, Columns, Values, and Filters areas show how the chart is built.

Use manual order for a sequence with business meaning, such as New, In progress, Waiting, Complete.
Use chronological order for dates, and check whether Excel is displaying individual dates, months, quarters, or grouped periods.
Use a deliberate numeric order for bands such as 1–5 or Small, Medium, Large, rather than relying on text sorting.
For a chart with a legend, reorder the column-field items if the series order—not the category labels—is what needs to change.

Manual ordering can make a chart easier to interpret, but keep the order consistent with the story the data tells. A custom sequence should not imply a ranking or progression that the underlying data does not support.

Manual order versus sorting by label or value

Manual sorting and automatic sorting solve different problems. Sorting A to Z or smallest to largest applies a predictable rule to the current labels. Sorting by a value field puts categories in a changing rank order, such as highest sales first. Manual sorting places items in a chosen sequence that may not follow either rule.

For example, if a PivotChart compares monthly revenue, sorting the months alphabetically would be misleading, and sorting them by revenue would answer a different question. A chronological sequence is the useful choice. If the goal is to show the strongest products first, sorting the product field by the revenue value may be more appropriate than manually arranging products.

To sort by values, use the PivotTable’s sorting controls for the relevant field and choose the value field that should determine the order. The chart will reflect that PivotTable sort. This order can change when the summarized numbers change, whereas a manually arranged sequence is intended to preserve a chosen order. Avoid switching back and forth without checking which sort is active; an automatic sort can replace or prevent the order you expected.

Keep the order useful after refreshes

Refreshing a PivotTable updates its summary from the source data. Existing manually arranged items may remain in their custom order, but a refresh can introduce new items or interact with the field’s sort settings. Therefore, inspect the chart after refreshing, especially when categories have been added, renamed, or removed. A new status or product does not automatically have an obvious position in a sequence you designed yourself.

For a one-off report, manually dragging labels may be enough. For a recurring report with a stable business sequence, consider maintaining a dedicated order in the source data. One common design is to add a separate sort-number column beside the category, with a unique number for each item. You can then sort the PivotTable using that number or use it to organize the source and verify the intended sequence. The exact setup depends on the PivotTable layout and whether the sort field is included in the report.

Another option for repeated text sequences is an Excel custom list, such as the days of the week or a company-specific workflow. Custom lists are managed in Excel’s options and can help Excel recognize a non-alphabetical order. PivotTable sorting can depend on the custom-list sorting setting and the workbook’s configuration, so test the result with a copy of the report before relying on it for a recurring refresh. Manual drag ordering is often the most direct method when only one PivotTable needs a custom sequence.

If several charts need the same order, check whether they share the same PivotTable or PivotCache and whether their fields are arranged consistently. A change to one connected PivotTable can affect its linked PivotCharts. Separate PivotTables may need their own ordering and checks.

Common problems and fixes

The chart order did not change: Confirm you moved an item in the field that supplies the chart category or series, not a different field. Then check that the chart is linked to the PivotTable you edited.
Excel keeps sorting the labels: An automatic label or value sort may be active. Open the field’s Sort options and select Manual if available, then try dragging again.
The item is missing from the chart: Check the field filter, chart field button, slicer, and report filters. A filtered-out item can have a position in the PivotTable without appearing in the chart.
Dragging is unavailable: Check Excel’s drag-and-drop setting, sheet protection, and whether you are selecting the item label rather than a value. Grouped fields may require expanding the group or rearranging at the appropriate field level.
The chart appears backwards: A chart-axis display setting can reverse the visual direction without changing the PivotTable’s item order. For a category axis, right-click the axis, choose Format Axis, and inspect the axis options for the reverse-order setting. This changes presentation, not the underlying PivotTable sort.

When diagnosing a mismatch, compare the PivotTable labels with the chart’s displayed labels after clearing filters. That separates an ordering problem from a filtering problem. Also verify whether the chart uses a date grouping; grouped dates may be controlled differently from individual source-date entries.

Excel for Mac and alternative approaches

In Excel for Mac, the same basic principle applies: rearrange the field items in the associated PivotTable, and the PivotChart follows. Ribbon and context-menu wording or placement can differ from Excel for Windows, so use the PivotTable’s field sorting controls or drag its item labels rather than expecting a separate chart-only manual sort. Excel for the web may also expose a different set of PivotTable controls; if a particular manual-sort option is unavailable in the browser, open the workbook in the desktop app.

If you need a chart whose categories are completely independent of PivotTable item order, create a regular chart from a helper range or a separate summary table. That gives you more direct control over the plotted range and order, but the helper data must be updated or designed to update when the source data changes. A normal chart is a useful alternative when the presentation sequence is unusual or when a PivotChart limitation prevents the exact formatting you need.

Another practical alternative is to place a numeric order field in the source and sort by it. This can be more maintainable than dragging dozens of labels after every structural change. For a small, stable set of categories, manual dragging remains simpler. Choose based on how often the data refreshes, whether new items are expected, and whether several reports must share the same sequence.

Frequently Asked Questions

Can I manually sort categories directly in a PivotChart?
Usually, no. Set the order in the chart’s associated PivotTable, because the PivotChart follows the PivotTable field order. Filters and axis formatting can affect what you see, but they are not substitutes for reordering the field items.

Can I put PivotChart months in calendar order?
Yes. Use a date field that Excel recognizes as dates and arrange or group it chronologically in the PivotTable. If month names are text, alphabetical sorting may place them incorrectly; use a real date field or a deliberate month order.

Will refreshing the PivotTable erase my manual sort?
Not necessarily, but do not assume the order will remain exactly as intended in every case. New categories and changed sort settings can affect the display. Check the PivotTable and chart after refresh, especially in recurring reports.

Why can I not drag a PivotTable item?
Possible causes include an active automatic sort, disabled drag-and-drop, sheet protection, selecting a value instead of an item label, or a grouped field. Check those conditions and use the field’s sort options before trying again.

Can I sort a PivotChart from highest to lowest?
Yes. Sort the associated PivotTable field by the value being charted, in descending order. The chart follows that order. This is a value-based sort, not a fixed custom sequence, so the ranking may change when the data changes.

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.