For an Excel sunburst chart, put each level of the hierarchy in its own column, from the broadest group to the most specific item, and put the numeric value for each lowest-level item in the final column. For example, use columns for Region, Department, Product, and Sales; select the table, then choose Insert > Insert Hierarchy Chart > Sunburst in Excel for Microsoft 365 on Windows.
The basic data layout
A sunburst chart shows nested categories as rings. Excel reads the category columns as successive levels of a hierarchy: the first category column is the highest level, and each column to its right describes a more specific level. The numeric column supplies the size of the chart segments. Each data row represents one path through the hierarchy to an item with a value.
A typical worksheet has one header row followed by the records, like this:
| Region | Department | Product group | Sales |
|---|---|---|---|
| North | Home | Cookware | 120 |
| North | Home | Lighting | 80 |
| North | Outdoor | Garden tools | 60 |
| South | Home | Cookware | 90 |
| South | Outdoor | Garden tools | 50 |
Here, Region is the outermost level of the hierarchy in the data and the first ring around the center of the chart. Department and Product group form the next rings. Sales determines the relative size of the terminal segments. The five values add up to 400, so the chart represents the distribution of that total. The repeated labels are intentional: the North and South cookware records belong to different paths.
How Excel interprets the hierarchy
Excel uses the order of the columns, not indentation or visual formatting, to identify the levels. A row with North, Home, Cookware, and 120 says that Cookware is a child of Home, which is a child of North. Several rows can share a parent; Excel groups those rows under that parent in the chart. The full path matters, so a category name such as Cookware can appear under more than one department or region without making those branches the same item.
The numeric value at the end of each row is assigned to its lowest-level category. The chart then shows parent groups as the combined size of their descendants. In the example, North has a total of 260 and South has 140. You normally do not need to add separate rows containing those parent totals: the chart can derive the parent segments from the leaf values.
That distinction is important. If you include a row for North with a total of 260 as well as its three product rows, you may count the North amount twice or create an unwanted category, depending on how the source is arranged. Keep the source consistent: list the lowest-level items and their values, and let the chart summarize the branches.
Prepare the source table
Before inserting the chart, make the source range rectangular and easy to interpret. Use a single header row, one column per hierarchy level, and one numeric value column. Keep the data records together, with no title line, blank separator row, or grand-total row inside the selected range. A clear table makes it easier for Excel to identify the labels and value series correctly.
- Use descriptive headings such as Region, Category, and Amount rather than leaving columns unnamed.
- Repeat parent labels on every row. Do not merge cells or leave parent cells blank to imitate a report layout.
- Use consistent category names and spelling. North, North Region, and N. Region will be treated as different labels.
- Make the final column numeric, not numbers stored as text. Use one meaningful measure, such as sales, units, or budget.
- Exclude subtotals and grand totals if they duplicate amounts already represented by detail rows.
One row per leaf path is usually the clearest arrangement. If the hierarchy has a different number of levels for some items, you may be tempted to leave cells blank. That can make the branch structure unclear, so consider adding a consistent label such as Other or Not specified where it accurately describes the data. Do not use a made-up label merely to fill a gap if it would misrepresent the categories.
Insert a sunburst chart in Excel
- Arrange the headers, hierarchy columns, and numeric values as described above.
- Select the complete source range, including its header row.
- On the ribbon, choose Insert > Insert Hierarchy Chart > Sunburst.
- Check that the chart shows the intended levels and that each branch has a sensible size.
- Use the chart design and formatting controls to add a title or adjust labels if the chart needs more context.
If Excel assigns the wrong field as a category or value, select the chart and open Chart Design > Select Data to inspect its source. The chart should use the hierarchy columns for category labels and the final numeric field for values. If it is easier, correct the source range or rearrange the columns, then insert the chart again. Excel for Mac also provides hierarchy charts from the Insert tab, though the ribbon grouping and wording can vary by release. Excel for the web may offer a different set of chart-editing controls; when a specific hierarchy option is unavailable, open the workbook in the desktop app.
Choose meaningful levels and values
The best number of hierarchy levels depends on the question the chart is meant to answer. Two or three category levels are often easier to read than a long chain of tiny nested segments. A retail chart might use Region, Department, and Product group. A file-usage chart could use Drive, Folder, and File type, with storage size as the value. Choose levels that describe real parent-child relationships, not merely columns that happen to be available.
Use a measure that makes sense to compare by area. Sales, number of units, hours, or storage size can work when the values are numeric and comparable across the tree. A category count can be represented by assigning a value of 1 to each leaf row, but that makes every listed leaf contribute equally; it does not show revenue or importance. If the data includes negative values, they do not translate naturally into positive segment areas. Decide how to handle refunds, losses, or corrections in the analysis rather than assuming a sunburst can communicate positive and negative amounts clearly.
Also consider the audience. A label like 2026 / Q1 / Product gives a recognizable path, while codes such as 04 / 17 / 82 need a legend or clearer category names. A chart can be mathematically correct and still be difficult to interpret if its labels are abbreviated or its branches contain many small segments.
Common layout problems and fixes
- The chart has an unexpected ring or category. Check whether the selected range includes a report title, total row, notes, or an extra field. Reselect just the header row and records.
- All values appear equal or the chart looks wrong. Confirm that the last column contains actual numbers and that the intended measure is selected. Text-formatted numbers may not behave as expected.
- Blank or unnamed branches appear. Look for empty cells in hierarchy columns, inconsistent records, or blank labels in the source. Fill them only with accurate categories, or correct the underlying records.
- A parent appears to be counted twice. Remove subtotal rows that repeat the combined values of their child rows. Keep detailed leaf records as the input.
- Similar labels seem merged. Excel groups matching category labels under the same parent path. Check for accidental duplicate spellings, extra spaces, or inconsistent naming. The same label under a different parent is a separate path.
- The chart is too crowded. Reduce the number of displayed levels, group minor categories into a truthful Other category, or filter the source to the question being asked. Many narrow segments are difficult to label and compare.
When investigating a suspicious segment, compare it with the source rows for that path. The parent size should correspond to the sum of its child values. This check often reveals a duplicated total, missing detail row, or text value before you spend time formatting the chart.
Sunburst versus treemap and other charts
A sunburst chart and a treemap both show hierarchical proportions, but they encode the structure differently. A sunburst uses nested rings, which makes parent-child paths visible as segments radiating outward. A treemap uses nested rectangles and can make efficient use of screen space, particularly when there are many categories. Neither is automatically better: use a sunburst when the levels and paths are central to the explanation, and consider a treemap when the chart has many items and space is limited.
A bar chart is often easier when the main task is comparing the exact values of a short list of categories. A sunburst is better suited to showing how a whole is divided across several nested levels. Its angles and areas are not as easy to compare precisely as aligned bar lengths, so it should not replace a table or bar chart when readers need exact rankings or close comparisons.
Frequently Asked Questions
What is the correct data format for a sunburst chart in Excel?
Use one column for each hierarchy level, ordered from broadest to most specific, followed by a numeric value column. Each row should describe one path to a lowest-level item.
Do I need to include totals for parent categories?
Usually not. Provide the values for the detailed items at the ends of the branches; Excel can represent parent groups using the combined child values. Adding parent totals alongside detail rows risks duplicating amounts.
Can I use text values as the size of a sunburst segment?
No. The segment sizes need numeric values. If you only want to show the number of leaf records, a value of 1 for each record can represent equal counts, but it will not encode a separate measure such as sales.
Can the same category name appear more than once?
Yes. A repeated label can appear in different branches because its parent path distinguishes it. Under the same parent, however, inconsistent spellings or accidental spaces can make what should be one category appear as separate categories.
Why does my sunburst chart show a blank segment?
Inspect the selected range for empty category cells, blank labels, or rows that do not contain a complete path. Correct the source with an accurate category or remove records that should not be charted; avoid filling blanks with an arbitrary label.
Final checks before sharing
Before sending the workbook, verify that the first column is the intended top-level group, the remaining category columns follow the parent-to-child order, and the last column contains the measure you want represented. Check that the chart does not include duplicate totals, that its labels make sense without relying on worksheet formatting, and that the source covers the intended records. A well-structured table is the most important part of a readable Excel sunburst chart; styling cannot repair a hierarchy that does not match the data.
Related
- Combine in Excel: Text, Cells, and Data
- Company Contact List Template for Excel
- Combine Excel Files into One: Methods and Best Practices
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Sort Pivot Table by Grand Total in ExcelTo sort a pivot table by the Grand Total column, click any cell inside the Grand Total row…
- Excel Histogram Format Options: Bins, Labels, and StyleIn Excel for Microsoft 365 on Windows, select a histogram and use Format Axis to change its bins,…
- Org Chart in Excel or Word? Choosing the Right ToolFor a straightforward org chart that is mainly a document, use Word; for a chart that sits alongside…
- Excel Chart Axis in Millions: Format Values ClearlyTo show an Excel chart axis in millions, select the axis, open Format Axis, and either choose Millions…
- Create a Pivot Table in Excel From Multiple Sheets?To create a PivotTable from multiple sheets in Excel for Microsoft 365 on Windows, combine the sheets’ data…
- Excel Pivot Table Divide by Zero Error: Causes and FixesAn Excel PivotTable’s #DIV/0! usually comes from a division formula in its source data or a calculated field…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.