Excel Pie Chart: How to Change the Order of Slices

To change the order of slices in an Excel pie chart, reorder the category and value rows in the chart’s source data; Excel plots slices in source-data order. To rotate the chart without changing that sequence, select the pie, open Format Data Series, and adjust Angle of first slice.

How Excel decides the slice order

A pie chart represents one data series divided among categories. In a typical source range, one column contains category names and the next contains their values. Excel uses the order of those rows as the order of the slices. For example, if a table lists North, South, East, and West from top to bottom, the chart follows that sequence around the pie.

This distinction matters because moving a slice visually and changing its place in the data sequence are different operations. Excel’s Angle of first slice setting rotates the complete pie. It can bring a particular wedge to the top or move a boundary to a more convenient position, but it does not make the categories follow a new order. To change which slice comes before another, change the source-data order.

Excel does not provide a simple command in the chart’s Select Data dialog for dragging individual pie categories into a new sequence. The dependable method is to arrange the source rows in the order you want, then let the chart update from that range.

Reorder slices by rearranging the source data

In Excel for Microsoft 365 on Windows, first identify the cells feeding the chart. Select the chart and choose Chart Design > Select Data to inspect the chart data range. You can also click a plotted slice and look at the formula bar to identify its series, but the Select Data dialog is usually easier for reviewing the full range.

Find the category labels and their corresponding values in the worksheet. Keep each label paired with its own value.
Rearrange the complete rows into the desired order. For example, move the row for East above the row for South if East should appear earlier.
Check that the chart’s source range still includes the intended labels and values. The chart should update automatically when its source cells change.
Review the finished chart and confirm that each slice still represents the correct category and amount.

Suppose the source table is Coffee 40, Tea 25, Juice 20, and Water 15, with each category on its own row. Moving the Juice row above Tea changes the plotted sequence to Coffee, Juice, Tea, Water while preserving the values attached to those names. The percentages and slice sizes do not change; only their order around the pie does.

If you want the largest slice first, sort the category and value rows together by the value column, largest to smallest. Select the whole data range before sorting, rather than sorting the numbers column by itself. Sorting only one column can pair a category with the wrong value, producing a chart that looks plausible but reports incorrect information.

Use a separate table for a chart-specific order

Sometimes the worksheet’s original order serves another purpose, such as matching a report, preserving entry order, or following a standard list. In that case, avoid rearranging the original data. Instead, create a small helper table in the order the chart should use, with each label beside its corresponding value, and base the pie chart on that table.

For instance, a sales report may list departments in the order they appear in an organization chart, while a presentation needs the same departments ordered by size. Keep the report table unchanged and make a second two-column range for the chart, arranging its rows by sales amount. This makes the chart’s intended order visible and reduces the chance that a later sort will disrupt other worksheet work.

To change which cells the chart uses, select the chart and choose Chart Design > Select Data. In the dialog, update the chart data range to the helper table, or edit the category-label and series-value ranges as appropriate. Make sure both ranges cover the same rows and that headers are not accidentally included as data. On Mac, the chart tools and Select Data controls are also available, though their placement can vary slightly with the ribbon layout. Excel for the web has chart editing controls as well, but some dialog details may differ from the Windows desktop version.

Rotate the pie without changing category order

If the category sequence is already right but an important slice sits in an awkward position, rotate the pie. Select a slice, right-click it, and choose Format Data Series. In the formatting pane, open Series Options and adjust Angle of first slice. You can type a degree value or use the control to change the orientation. The full pie turns, but the source order, category names, and values remain the same.

This is useful when you want to keep a small slice from straddling the top of the chart, make a key category easier to see, or align a chart with a layout. The correct angle depends on the values and the desired position, so adjust it while viewing the chart. Rotating does not move a category to a new place in the underlying sequence; if the order itself is wrong, rearrange the source rows instead.

To format the series, make sure you select a slice rather than the chart area or legend. If the pane shows formatting options for the chart area, close it, select a wedge, and reopen the series formatting pane. On Mac, use the chart formatting controls to open the data-series options; the wording and pane layout can differ slightly by version.

Sort slices by value or choose a custom sequence

Sorting by value is a common choice when the goal is to make relative size easier to scan. A descending order places the largest value first, followed by progressively smaller values. An ascending order can be useful when the smallest categories deserve attention, although tiny wedges may still be hard to distinguish in a pie chart.

A custom sequence is often better when the categories have a meaningful progression: for example, stages such as Planning, In progress, Review, and Complete. In that situation, alphabetical or size-based sorting could obscure the intended story. Arrange the rows in the meaningful order, or use a separate helper table for the chart. Add a clear label or note if the order is not obvious to readers.

When working with a table, sorting the table by a column generally keeps the values and their labels together, and a chart linked to the table can reflect the revised row order. Still, verify the chart after sorting, especially if the source range is a manually selected cell range or the workbook includes multiple related tables. The chart’s displayed order is determined by the cells it actually references, not by a different list elsewhere on the sheet.

What Select Data and Switch Row/Column can—and cannot—do

Chart Design > Select Data is useful for checking or changing the chart’s source range, editing a series, and correcting category labels. It is not an individual-slice organizer. If the pie uses a contiguous range, the most direct way to change its order is to rearrange rows inside that range or point the chart at a reordered helper range.

Switch Row/Column changes how Excel interprets the selected data, exchanging rows and columns as series and categories where the chart type supports that arrangement. It is not a general-purpose reverse-order button for the slices in a single-series pie chart. If switching makes the chart confusing or changes its meaning, use Undo and reorder the source categories instead.

Likewise, clicking a wedge and dragging it is not a reliable way to establish a new data order. Pie-chart formatting can include options such as separating or exploding a point, but highlighting a wedge is not the same as moving its category in the sequence. Keep visual emphasis and data ordering as separate decisions.

Common problems and how to fix them

The chart does not change after rows are moved. Check Chart Design > Select Data and confirm the chart refers to the cells you edited. It may use a different range, a helper table, or a chart-specific series definition.
Names no longer match the slice sizes. The label and number may have been sorted separately. Undo the sort if possible, then select and sort the full category-and-value range together.
The order changes when someone refreshes or updates the data. If the source is generated by a report, query, or another process, the next update may restore its original order. Use a chart-specific helper range or control the order in the process that supplies the data.
The chart shows an unexpected category. Inspect the source range for extra rows, blank cells, totals, or headers included as data. Correct the range before adjusting the slice order.
The pie looks crowded after reordering. Reordering cannot make numerous similar or very small values easier to compare. Consider grouping minor categories or using a bar chart when precise comparisons matter.

Before making a substantial change to a workbook used by others, it can help to save a copy or note the original row order. Sorting a range can affect more than the chart if those cells support other calculations or report layouts. A helper table keeps the original source intact and makes the chart’s sequence easier to maintain.

When a pie chart may not be the best choice

A pie chart works best when the categories are parts of one whole, the values are nonnegative, and there are only a few categories that readers can distinguish. If the main question is which category is larger or how close two values are, a sorted bar chart is often easier to read because people can compare lengths against a common scale. A pie chart’s slice order can help guide the eye, but it does not make close values more precise.

For example, a chart with four expense categories can be arranged from largest to smallest to establish a clear visual sequence. A chart with twelve categories, several of them tiny, may become difficult to interpret even after sorting. In that case, consider a bar chart, or combine minor categories only if doing so is appropriate and the grouping is explained. Changing slice order is a presentation choice, not a substitute for choosing a chart type suited to the data.

Frequently Asked Questions

Can I drag pie slices into a different order in Excel?
No, dragging a wedge is not the standard way to reorder pie categories. Reorder the corresponding source-data rows, or create a helper table in the desired order and use it as the chart source.

How do I reverse the order of slices?
Reverse the order of the category-and-value rows together in the chart’s source range. Verify that every category remains paired with its original value, then check that the chart references the reordered range.

Does Angle of first slice change the order?
No. It rotates the pie so the first slice begins at a different position. The category sequence remains the same; change the source-data order to change the sequence.

Can I sort pie-chart slices from largest to smallest?
Yes. Sort the complete source range by the value column in descending order, keeping labels and values together. If the original table must stay in its existing order, make a separately ordered helper table for the chart.

Why does the chart order not match my worksheet?
The chart may point to a different range than the one you changed, or it may use a helper table or a source that is refreshed separately. Select the chart and inspect Chart Design > Select Data to confirm its actual source.

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.