How to Sort an Excel Pie Chart from Largest to Smallest

To sort an Excel pie chart from largest to smallest, sort the chart’s source data by its value column in descending order: select the full data range, choose Data > Sort, select the value field, and set Order to Largest to Smallest. Excel then displays the pie slices in the same order as the sorted source rows; there is no separate command that rearranges pie slices independently of their data.

Why sorting the source data works

A pie chart represents categories and their values, and Excel uses the order of the source rows to determine the order of the categories in the chart. For example, if a chart is based on a list of product names and sales figures, the first product row supplies the first category, the next row supplies the next category, and so on. Sorting those rows by sales changes the category sequence in the chart.

Sorting changes the order in which slices are presented, not their sizes. A slice’s size still comes from its value relative to the total of the plotted values. If sales are 50, 30, and 20, those slices remain 50%, 30%, and 20% of the total after sorting; sorting only makes the 50-value category appear first in the series order.

This is useful when readers need to compare the biggest categories quickly, when a legend should follow the same ranking as the slices, or when a chart is used in a report. It is especially helpful with several categories, where an unsorted pie can make the ranking harder to spot.

Sort an existing pie chart step by step

Suppose the source data has Category in column A and Amount in column B, with headings in row 1. The pie chart uses the category names and amounts. Use these steps in Excel for Microsoft 365 on Windows:

Click a cell inside the source data, not a slice in the chart.
Open the Data tab and choose Data > Sort. In the Sort dialog, confirm that My data has headers is selected if the first row contains headings.
In Sort by, choose the column containing the amounts. Set Sort On to Values and Order to Largest to Smallest.
Choose OK. If Excel asks whether to Expand the selection or Continue with the current selection, choose Expand the selection so each category stays attached to its amount and other row details.
Check the chart. It should update to reflect the new order of the source rows.

If the chart does not update, verify that its data source includes the rows you sorted. Select the chart and use Chart Design > Select Data to inspect the chart data range. If the range is correct but the chart still shows an unexpected sequence, check for hidden rows, filters, or a PivotChart, which may use sorting rules from its associated PivotTable.

On Excel for Mac, sort the source range using the Data tab’s sort controls; the same principle applies. In Excel for the web, sort the source table or range using the Data tab. Ribbon layouts can differ slightly by platform, but sorting the chart’s underlying rows is the key step.

Keep categories and values together

The most important precaution is to sort complete records, not just the numeric cells. If you sort only the amounts in column B, the names in column A stay where they are, and the chart may pair a category with the wrong amount. The same issue can affect extra fields such as region, date, department, or product code.

When data is in an Excel table, clicking a cell in the table and sorting by the amount column normally sorts the table’s rows together. You can also select the full range before sorting. In the Sort dialog, check the header setting so Excel treats the column names as labels rather than as data. If Excel prompts you to expand the selection, expand it.

For example, imagine a table with these rows: North, 420; South, 275; East, 510; and West, 195. Sorting the complete table by Amount, Largest to Smallest, gives East, 510; North, 420; South, 275; and West, 195. The chart then follows that sequence. Sorting only the amount cells would leave the region labels in their original order, producing misleading category-value pairings.

If the source includes subtotals, blank rows, or separate blocks of data, review the selection carefully before sorting. A blank row can cause Excel to treat adjoining data as separate regions. A safer approach is to convert a continuous dataset into a table with clear column headings, then sort the table.

What order will appear in the chart?

After sorting, the chart’s category sequence follows the source data order. This usually means the largest category is first in the series and the smallest is last. The legend also generally follows the category order, although its position and layout depend on the chart formatting.

That does not guarantee that the largest slice will start at the very top of the circle. The chart’s starting position can be rotated, and the slice sequence proceeds around the pie from that starting angle. To adjust the orientation, right-click a slice, choose Format Data Series, and use Angle of first slice under Series Options. Changing this angle rotates the pie; it does not change the data ranking or the values.

Excel’s default colors and the placement of labels may also make a sorted chart look less obviously ranked than expected. If the goal is to show a clear visual ranking, keep the descending source order, use a readable legend or direct labels, and avoid manually changing individual point colors in a way that implies a different order.

Use tables, filters, and PivotCharts carefully

If the chart is linked to an Excel table, sorting the table is convenient because the chart can continue to use the table’s structured data as rows are added or removed. The chart reflects the current order of the included data. If the chart’s source was instead set to a fixed cell range, new rows added below that range may not appear automatically; inspect Chart Design > Select Data if the chart omits records.

Filters can affect what the chart displays. If rows are filtered out, the chart may omit them depending on its hidden and empty cell settings. Sorting visible rows is not the same as sorting every row in the underlying dataset, so check whether a filter is active before interpreting the chart as a complete ranking.

A PivotChart is different from a standard chart because its categories and values come from a PivotTable. Sort the PivotTable’s row items by the value field, rather than sorting the original worksheet cells and expecting the PivotChart to follow that order. Open the row-field dropdown, use its sort options, and choose a descending sort by the relevant value, such as Sum of Amount. The available wording can depend on the PivotTable layout and value-field name.

For a chart based on a PivotTable, refresh the PivotTable if the source data changed and the chart has not caught up. Also confirm that the value being sorted is the same measure represented by the pie. A PivotChart may summarize many source rows into one value per category, so the ranking can differ from a sort of the raw records.

Labels and percentages after sorting

Sorting the source data does not normally remove chart labels, change the underlying numbers, or recalculate a category’s share incorrectly. It changes the order of the plotted categories. If labels show values or percentages, those labels should remain associated with their respective slices as long as the source rows were sorted together.

To add or adjust labels, select the chart and use Chart Design > Add Chart Element > Data Labels, then choose a placement. You can also right-click a data label and choose Format Data Labels to select options such as Category Name, Value, and Percentage. The exact choices shown depend on the chart and Excel build.

Percentages are calculated from the values included in the pie chart, not necessarily from every row in the worksheet. For instance, if a chart includes values 50, 30, and 20, the percentages are 50%, 30%, and 20%. If it includes only 50 and 30, their shares of the plotted total are 62.5% and 37.5%. Confirm the chart’s source range and filters if the percentages do not match a total calculated elsewhere.

Common problems and fixes

The slices did not change order: Sort the source data, not the chart object. Then confirm the chart points to the range you sorted.
The values no longer match the category names: Undo the sort if possible, then sort the full table or range rather than one column alone.
The largest slice is not at the top: The data can be correctly sorted while the pie is rotated. Adjust Angle of first slice if a different starting position is important.
One or more categories are missing: Check filters, hidden rows, blank rows that split the data range, and the chart’s selected source range.
The chart order keeps changing: A PivotChart, refreshed data, or a formula-generated source range may be controlling the order. Identify the actual chart source and apply the sort there.
Some values are zero or negative: A pie chart is intended to show parts of a whole and is not a good way to represent negative quantities. Review the data and choose a chart type that can communicate the values accurately if the series includes negatives.

For formula-generated lists, remember that the chart follows the order of the cells it references. If those cells are produced by a formula, changing the original table’s manual sort may not alter the displayed order. In that case, adjust the formula or sort the output range using an appropriate supported method, then check that the chart references that output.

When another chart type may be clearer

A descending pie chart is reasonable when there are only a few categories and the purpose is to show each category as a share of one total. It is less effective when there are many small slices, several categories with similar values, or negative values. Labels can crowd, and readers may struggle to compare angles precisely.

A sorted horizontal bar chart is often easier to scan when the main question is which categories rank highest. It provides a common baseline for comparing lengths, accommodates longer category names, and can display many categories more clearly. A column chart can also work for a short ranking, though long labels may be harder to fit. The choice depends on whether the emphasis is part-to-whole composition or category comparison.

Do not add an “Other” slice without deciding which categories it combines and how that total was calculated. If you group small categories, keep the detailed source data intact and make the grouping transparent in the chart or a note. That preserves traceability while keeping the display readable.

Frequently Asked Questions

Can I sort pie chart slices without sorting the worksheet data?
No, not with the standard pie chart controls. Sort the chart’s source rows in the order you want. If you need a different display order while preserving the original table, make a separate sorted output range and base the chart on that range.

Does Largest to Smallest make the biggest slice start at 12 o’clock?
No. It controls the order of categories in the series, while Angle of first slice controls the pie’s rotation. You can adjust the angle without changing the ranking.

Why did Excel sort the names but not the numbers?
This can happen if only one column was selected and the current selection was sorted by itself. Undo the operation, select the complete dataset, and sort by the value column. Choose Expand the selection if Excel asks.

Can I sort a PivotChart from largest to smallest?
Yes. Sort the categories in the associated PivotTable by the value field in descending order. Sorting the original raw data alone does not necessarily control the order of PivotTable categories.

Will sorting change the percentages on my pie chart?
Sorting alone does not change the plotted values or their shares; it changes their order. Percentages can differ from an expected worksheet total if the chart excludes rows, uses filters, or references a different range.

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.