To change the order of slices in an Excel sunburst chart, reorder the chart’s source rows: in Excel for Microsoft 365 on Windows, select the complete source table, choose Data > Sort, and sort the hierarchy categories in the order you want. Excel generally follows the order in which categories appear in the source for sibling slices; there is no simple Sunburst-chart dropdown for sorting slices independently of the data.
How Excel decides the order
A sunburst chart displays hierarchical data as concentric rings. The first category column in the source is the top-level group, each column to its right is a deeper level, and the final numeric column supplies the values that determine the sizes of the slices. For example, a table with Region, Department, Product, and Sales columns makes regions the inner ring, departments the next ring, and products the outer ring.
Excel builds the chart from the worksheet’s category paths and the order in which those categories occur. Rows with the same path contribute to the same branch, and the chart aggregates their values. This means the data’s row order can affect the displayed sequence of sibling categories, but it does not change which categories belong together or the numeric proportions. Sorting the source is therefore the practical way to reorder branches.
Keep the distinction between ordering and sizing in mind. Sorting rows changes where categories appear around the chart; it does not change their values. A larger value still occupies a larger portion of its parent’s ring, whatever its position in the sequence.
Sort the source table to reorder slices
For a predictable result, sort the entire data range, not just one category column. Sorting only a single column can detach category names from their associated departments, products, or values. If the source is an Excel table, click inside it before sorting so the records stay together.
- Click a cell in the chart’s source data. Check that each row contains a complete category path and its associated value.
- Open Data > Sort. If Excel asks whether to expand the selection, choose to expand it so every column in each record moves together.
- In the Sort dialog, choose the hierarchy column whose sibling categories you want to order. Set the sort order to A to Z, Z to A, or another available order.
- For a multi-level order, use Add Level to sort first by the parent category and then by the child category. Click OK.
- Check the sunburst chart. If it does not reflect the intended order, confirm that the chart uses the range you sorted and that the sort keys express the order you want.
For example, suppose the source has rows for North / Hardware / Drills, North / Hardware / Saws, North / Software / Design, and South / Hardware / Drills. Sorting by Region, then Department, then Product groups and orders the paths in those levels. The chart still represents the same regions, departments, products, and sales totals; only the presentation sequence changes.
Set a custom order instead of alphabetical order
Alphabetical sorting is convenient, but it is not always meaningful. A report might need the regions East, Central, West, or the stages Planning, In progress, Complete, even though those are not alphabetical. In that case, give each category an explicit rank in helper columns and sort by those ranks.
For instance, add a Region Rank column with 1 for East, 2 for Central, and 3 for West. Add similar rank columns for departments or products if their order also matters. Use Data > Sort to sort first by Region Rank, then by Department Rank, and then by Product Rank. Keep the rank columns in the source range used for sorting, but exclude them from the chart’s category and value fields; otherwise Excel may treat a rank as another hierarchy level.
Another option is to use Excel’s custom list sorting for a known sequence. In the Sort dialog, select the relevant category column and look for a Custom List order. Availability and the dialog details can vary with the Excel build and platform. Helper ranks are usually easier to audit and maintain, particularly when several people update the workbook or when category order changes over time.
- Use A to Z or Z to A when the category order should be alphabetical.
- Use helper ranks when the order represents a process, priority, or business convention.
- Use multiple sort levels when the order of children should restart within each parent group.
Change the hierarchy level order
Changing the order of slices within a ring is different from changing which category appears in each ring. Excel reads the hierarchy from the source columns from left to right. If the columns are Region, Department, and Product, Region is the top level and Product is the deepest level. Moving or rebuilding the source columns can change the hierarchy, but it also changes the meaning of the chart.
Before changing column positions, decide which category should be the root group and which should be the most detailed category. Then arrange the category columns in that order, with the numeric value column last. If the existing chart does not update as expected after changing the source layout, use Chart Design > Select Data to inspect the chart’s data range, or create a new sunburst chart from the corrected range. Avoid swapping labels merely to get a preferred visual: a chart with the wrong parent-child relationships can be misleading even if it looks tidy.
In a typical source table, each row represents a path through the hierarchy and the amount associated with that path. For example, North / Hardware / Drills / 120 records sales for that path. Repeated paths can be useful when separate transactions roll up to the same product; Excel combines their values in the chart. The category columns must still identify the intended path consistently.
Refresh and check the chart after sorting
A chart based on ordinary worksheet cells usually updates when those cells are sorted, because the chart still refers to the same range. A chart based on an Excel table can also respond as the table’s records are reordered. If the display appears unchanged, verify the source range rather than assuming Excel ignored the sort.
- Use Chart Design > Select Data to check which cells feed the chart.
- Make sure the header row is not accidentally included as a data category and that the value column contains numbers.
- Check for blank category cells. A blank in a hierarchy can create an incomplete path or an unexpected grouping.
- Confirm that sorting did not exclude rows at the top or bottom of the source range.
- Compare a few visible branches with the underlying rows to ensure the parent-child assignments remain correct.
If the chart was created from a range that does not include newly added rows, sorting alone will not add those rows to the chart. Converting the source to an Excel table before creating the chart can make the source easier to extend, but always check the chart’s data range after substantial changes.
What sorting can and cannot change
Sorting changes category sequence; it does not rotate the chart to a chosen starting point, reverse the hierarchy, or alter the value-based slice sizes. Excel does not provide a straightforward Sunburst-specific control for freely dragging slices into a custom order. If your goal is to put one particular branch at a particular compass position, rearranging the data may change the sequence, but it is not the same as independently positioning a slice.
Similarly, sorting by sales value is not a command that changes the chart’s data. It rearranges the rows so that categories appear in a different sequence. If the rows are sorted by the value column alone, categories from different parent groups can be interleaved in the worksheet. The chart still groups categories by their hierarchy paths, but the result may be harder to inspect or maintain. For clearer data, sort by the parent categories first and use value as a later sort level only when that ordering is actually wanted within each parent.
Do not confuse the size of a slice with its order. A product with sales of 500 should have a larger slice than a sibling with sales of 100, regardless of whether the 500 row comes first or last. If sizes look wrong, check the values, the selected range, and whether the intended records share the correct category path.
Windows, Mac, and Excel for the web
The steps above use Excel for Microsoft 365 on Windows. On Windows, the main paths are Data > Sort for ordering the source and Chart Design > Select Data for inspecting the chart range. Ribbon labels or dialog placement can differ slightly between builds, but the underlying approach is to sort the chart’s source records.
Excel for Mac also supports sorting worksheet data and creating hierarchy charts, though ribbon organization and dialog details may differ from Windows. Excel for the web can handle common table sorting and chart editing, but some advanced sort options and chart-formatting controls may be more limited or placed differently. If a custom sequence is essential and the web interface does not expose the needed sort choice, use helper rank columns or open the workbook in the desktop application.
Common mistakes to avoid
The most damaging mistake is sorting one category column without expanding the selection. That can associate a product with the wrong department or value. Another frequent problem is expecting the chart to sort categories by their numeric values automatically. A sunburst chart visualizes the hierarchy; it does not replace the source-data sort with a universal automatic ranking rule.
- Do not delete or move category columns without checking how the chart interprets the hierarchy.
- Do not include helper sort ranks as chart categories unless they are genuinely part of the hierarchy.
- Do not sort by a child category alone if you need parent groups to remain in a deliberate order.
- Do not judge the result only by slice size; verify the labels and paths as well.
If a branch seems to be missing, look for empty cells, misspelled category labels, or values stored as text. For example, “Hardware” and “hardware” may be treated as the same label in some contexts, while “Hardware ” with a trailing space can behave like a distinct category. Clean and standardize the source labels before attempting to fix a chart-order issue.
Frequently Asked Questions
Can I drag a sunburst slice to a new position?
No. Excel does not offer a simple drag-to-reorder control for sunburst slices. Reorder the source data, using helper ranks for a custom sequence, and let the chart reflect that source order.
How do I reverse the order of the categories?
Sort the relevant source category column in the opposite direction, such as Z to A instead of A to Z. For a deliberate non-alphabetical reverse sequence, use ranks and sort those from largest to smallest.
Can I sort the sunburst slices from largest to smallest?
You can sort the source rows by value, but do so with care. To rank items within each parent, sort by the parent category first and by the value second. A value-only sort can make the worksheet’s hierarchy paths harder to follow, and it does not change the values represented by the chart.
Why did sorting the sheet not change the chart?
Check whether the chart points to the range you sorted and whether all rows were included in the sort. Also check whether you sorted only one column. Use Chart Design > Select Data to inspect the source, then sort the complete records again if needed.
Can I change which ring appears first?
Change the order of the category columns in the chart’s source hierarchy, with the intended top-level category first. This changes the hierarchy itself, not just the display order, so confirm that the new parent-child structure communicates the data correctly.
Related
- Excel Shortcut to Select an Entire Column
- Excel Shortcut to Select to the End of a Column Explained
- Excel Shortcut to Refresh a PivotTable and All Data
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Stacked Bar Chart Not Proportional? Fix the ScaleIf an Excel stacked bar chart does not look proportional, first check whether it is a regular Stacked…
- How to Make a Chart in Excel Run From Right to LeftTo make an Excel chart read from right to left, select the axis you want to reverse, right-click…
- Excel Dashboard GitHub: Find and Use Templates SafelyTo find an Excel dashboard on GitHub, search GitHub for terms such as “Excel dashboard xlsx” or “Excel…
- Excel Pivot Table: How to Use the Same Field TwiceYes. In Excel for Microsoft 365 on Windows, you can add the same source field to a PivotTable’s…
- Excel Graph Reverse Data Order: Flip an Axis or SeriesTo reverse the order of categories in an Excel graph, select the chart, right-click its category axis, choose…
- Excel Pivot Table Data Source Not Valid? Fix ItThe Excel message “The data source reference is not valid” usually means Excel cannot resolve the range, table,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.