Excel Pivot Chart Sort by Value: Steps, Tips, and Fixes

To sort an Excel PivotChart by value, sort the corresponding field in its PivotTable: right-click a number in the value column, choose Sort, then choose Sort Largest to Smallest or Sort Smallest to Largest. The PivotChart follows the PivotTable’s category order; sorting the chart itself is generally not the control you need.

Why the PivotTable controls the chart order

A PivotChart is linked to a PivotTable. The PivotTable organizes the underlying categories and calculated values, while the chart presents that summarized data visually. As a result, sorting a category in the PivotTable normally changes the order of the matching categories in the chart as well. For example, sorting a PivotTable of product revenue from largest to smallest puts the highest-revenue products first in the table and reorders the chart’s product categories to match.

This is different from sorting an ordinary chart’s source range. A standard chart may use a worksheet range whose rows you can rearrange directly. A PivotChart is managed through its PivotTable fields, filters, and summary calculations. Clicking a bar or column selects a chart element; it does not usually provide a command to sort the PivotChart independently of the PivotTable.

The distinction between categories and series matters. In a chart of sales by product, products are often the categories and regions are the series. Sorting the product field changes category order. Sorting a region field may change series order instead, or may organize categories within each region, depending on the PivotTable layout.

Sort categories by a value in Excel 365

Use the following steps in Excel for Microsoft 365 on Windows. The example assumes a PivotTable with product names in the row area and a measure such as Sum of Revenue in the values area.

Click a number in the PivotTable’s value column, not a product name or a chart element. Choose a value belonging to the measure you want to use for sorting.
Right-click the number. On a touchpad or a Mac, use the appropriate secondary click or Control-click.
Choose Sort, then choose Sort Largest to Smallest for descending order or Sort Smallest to Largest for ascending order.
Check the PivotTable and the PivotChart. The category order should now reflect the selected value order.

This quick method is convenient when the right measure is obvious. If the PivotTable has several value fields, the number you click determines which measure Excel uses. For instance, a PivotTable might show both Sum of Revenue and Sum of Units. Right-clicking a revenue figure sorts products by revenue; right-clicking a units figure sorts them by units.

Choose the value field explicitly

For more control, open the menu for the category field in the PivotTable, such as the drop-down beside Row Labels or the product field name. Select More Sort Options. In the sort dialog, choose descending or ascending order and specify the value field to sort by, such as Sum of Revenue. Confirm the choice to apply it.

Field names and dialog wording can vary with the layout and Excel build. If the drop-down is not visible, click inside the PivotTable and look for the field’s filter button or use the contextual PivotTable ribbon. The important setting is a value-based sort for the category field, not an alphabetical sort of the item labels.

Explicitly selecting the measure is useful when the PivotTable contains multiple metrics, or when the current sort is confusing. It also makes the intention clearer to someone reviewing the workbook: the categories are ordered by a particular calculated value, rather than by their names.

Sort ascending, descending, or by another measure

Descending order is the common choice for a ranking chart because the largest value appears at one end of the category sequence. Ascending order is useful for showing the smallest values first, identifying low performers, or presenting a deliberate progression. The direction changes the order in the PivotTable; the chart’s visual orientation can make the result appear different, as described below.

You can sort by any suitable value field included in the PivotTable, not only the field currently emphasized in the chart. For example, a report containing product, Sum of Revenue, and Sum of Profit can be sorted by revenue or profit. The order will represent the chosen measure even if the chart displays more than one series. Check the legend and axis titles so readers do not mistake the ranking measure for another displayed metric.

For example, suppose three products have revenue of $12,000, $8,500, and $15,000. A descending sort by Sum of Revenue orders them at $15,000, $12,000, then $8,500. Sorting by units sold could produce a different order. A chart’s tallest bar is not necessarily the first category unless the category field is sorted by the same measure and the chart orientation displays the sequence as expected.

Understand chart axes and apparent reverse order

A correct PivotTable sort can look reversed in a horizontal bar chart. Excel may display the first category at the bottom of the vertical category axis, so a largest-to-smallest table order can appear bottom-to-top rather than top-to-bottom. This is an axis display issue, not necessarily a failed sort.

To change the visual direction, right-click the chart’s category axis and choose Format Axis. In the Format Axis pane, look for Categories in reverse order and adjust it. The exact result depends on the chart type and axis arrangement; changing this setting affects how categories are drawn, not the underlying PivotTable sort. Check the value axis afterward, because reversing categories can also change where that axis crosses.

For a vertical column chart, categories run along the horizontal axis and the first sorted item is typically shown at the left. A bar chart places categories on the vertical axis, where the first item may be at the bottom. If a ranking needs the largest item at the top, decide separately whether you want to change the PivotTable sort, the axis display order, or both.

Sort within groups and handle multiple fields

When the PivotTable has nested row fields—for example, Region followed by Product—a product sort may apply within each region rather than creating one global list of products. Each group can therefore have its own highest-revenue item at the top. This is often appropriate when the chart compares products within regions, but it is not the same as ranking every product across the entire business.

To create a global ranking, simplify the PivotTable layout so the category you want to rank is the relevant row field, or build a separate PivotTable with the desired category and measure. A PivotChart only summarizes the arrangement and filters of its associated PivotTable; it cannot reliably show a global ranking that conflicts with the table’s grouping structure.

Column fields can also affect what a sort means. If months are columns and products are rows, sorting products by a value may refer to a particular value field or column context. If the goal is to rank by total revenue across all months, ensure the sort is based on the grand total or the intended total measure, rather than a single month’s value.

Keep the order after filtering or refreshing

Filters change which records contribute to the summary, and a value-based order may need to be checked after the PivotTable is filtered or refreshed. If the report is intended to show the current ranking, refresh the PivotTable and verify that the category order still matches the displayed measure. Use PivotTable Analyze > Refresh to refresh the selected PivotTable, or use Data > Refresh All when the workbook has multiple connected data sources or PivotTables to update.

A sort can be preserved as a PivotTable setting, but changes to source data, filters, grouping, or the available items can alter the results and what appears in the chart. If new categories appear after a refresh, inspect the values and sort again if necessary. For a report that must always show a fixed number of leaders, consider a value filter such as a Top 10 filter on the row field, then verify its value field and settings. A Top 10 filter controls which items are included; it is distinct from simply sorting all items.

In Excel for Mac, the same general approach applies: sort through the linked PivotTable, using a secondary click or Control-click where needed. Ribbon placement and dialog presentation can differ slightly by Excel version. Excel for the web also supports PivotTable work, but some PivotTable and chart controls may be more limited or arranged differently than in the Windows desktop app; use the desktop app if a specific sort dialog or formatting control is unavailable.

Common sorting problems and how to fix them

The chart does not change: Confirm that the PivotTable you sorted is the one linked to that PivotChart. A workbook can contain several tables and charts with similar labels.
Items sort alphabetically: You may have sorted the label field rather than a value. Right-click a numeric value or use More Sort Options to specify the measure.
The ranking uses the wrong metric: The PivotTable may contain several measures. Choose the intended value field explicitly, such as Sum of Profit rather than Sum of Revenue.
Only items within a group reorder: The field is nested under another row field. Simplify the layout or create a separate PivotTable for an overall ranking.
The top bar appears at the bottom: The PivotTable order may be correct, while the bar chart’s category axis displays the first category at the bottom. Adjust the axis display setting if needed.
Some categories are missing: Check report filters, slicers, value filters, and whether the source data includes those items. Sorting changes order, not which filtered-out items are included.

Also check the summary calculation. A field summarized by Count or Average will rank differently from one summarized by Sum. In the PivotTable, open the value field settings if the chart’s ranking seems inconsistent with the source figures. Sorting is only as meaningful as the calculation being sorted.

PivotChart sorting versus a regular chart

A PivotChart is useful when you want the chart to respond to PivotTable filters, slicers, and refreshed source data. Its categories follow the PivotTable structure, which keeps the summary and chart connected but means the chart does not have an independent category sort order.

A regular chart can be a better choice when you need a presentation-specific order that differs from the PivotTable, or when you want to arrange a small set of categories manually. One option is to create a separate, appropriately ordered summary range and build a standard chart from it. That approach offers more direct control over the chart’s source order, but it also means the separate range must be maintained or updated as the underlying data changes.

For a live report, sorting the PivotTable is usually simpler and less fragile. For a carefully designed dashboard with a custom order, a separate chart source may be worthwhile. Choose based on whether linked filtering and refresh behavior or independent presentation control matters more.

Frequently Asked Questions

Can I sort a PivotChart without sorting its PivotTable?
A PivotChart generally follows the sort order of its associated PivotTable, so sort the relevant row or column field there. If you need a different, independent chart order, create a regular chart from a separate summary range.

How do I sort a PivotChart from highest to lowest?
Right-click a value in the PivotTable for the measure you want to rank by, choose Sort, then Sort Largest to Smallest. The chart should reflect the resulting category order.

Why is my largest bar at the bottom?
In a horizontal bar chart, the first category in the PivotTable sort may display at the bottom of the category axis. Check the PivotTable order, then adjust the axis’s Categories in reverse order setting if you want the largest category at the top.

Can I sort by a calculated value such as profit margin?
You can sort by a value field included in the PivotTable, including an appropriate calculated field or measure. Make sure the field is actually present in the PivotTable’s Values area and select it as the sort basis.

How do I show only the top products?
Use a value filter on the product field, such as a Top 10 filter, and choose the measure and number of items that define the ranking. A value filter limits the categories shown; sorting alone only changes their order.

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.