Creating a Sunburst Chart in Excel: Step-by-Step

Charts & pivot tables · Updated November 19, 2026

To create a Sunburst chart in Excel for Microsoft 365 on Windows, arrange your data in columns from the broadest category to the most detailed category, with a numeric value in the final column. Select the data, then choose Insert > Insert Hierarchy Chart > Sunburst. Excel turns the category levels into rings, with the top-level group nearest the center.

What a Sunburst Chart Shows

A Sunburst chart is a circular chart for showing how parts relate to larger groups. Each ring represents a level in a hierarchy: the center contains the highest-level categories, and rings farther out show increasingly specific categories. The size of each segment represents its value, so viewers can compare both the composition of a whole and the relative size of its subgroups.

For example, a retailer could show sales by region, product category, and individual product. The innermost ring would show regions; the next ring would divide each region into categories; and the outer ring would show products. The chart is useful when the hierarchy itself matters, not just the total for each item.

A Sunburst is not simply a pie chart with extra decoration. A pie chart displays one level of categories, while the Sunburst nests multiple levels. If there is only one level to compare, a bar chart or pie chart is usually easier to read. If you have many levels or a large number of small categories, the rings can become crowded.

Prepare the Data as a Hierarchy

Excel needs a column for each category level and a numeric measure in the last column. Each data row should describe one end item, also called a leaf in the hierarchy. Use a consistent order from broad to specific, because the column order determines the rings from the center outward.

For instance, a simple sales table might have the headings Region, Department, Product, and Sales. Example rows could be North, Furniture, Desk, 12; North, Furniture, Chair, 8; and North, Technology, Tablet, 15. These values could represent units sold or thousands of dollars, as long as the same measure is used throughout. Excel combines the values for Desk and Chair to size the Furniture segment; you do not need to add a separate Furniture subtotal row.

Before inserting the chart, check that the table is tidy:

  • Put one heading in each column, and make the headings descriptive.
  • Use one consistent label for each category. Avoid spelling variations such as Technology and Tech if they mean the same group.
  • Give each row a complete path from its top-level category to its detailed item. Missing levels can produce unexpected or blank-looking segments.
  • Enter numeric values in the measure column. Text such as twelve, currency symbols stored as text, and empty cells can prevent values from being interpreted as intended.
  • Do not include parent subtotals alongside their child rows unless you deliberately want those values counted as additional items. Including a department total and its product sales can double-count the department.

Sunburst charts are most natural for positive part-to-whole data. A negative value cannot be represented as a normal positive arc size in a way that preserves the meaning of a hierarchy. If the measure includes losses, changes above and below zero, or net balances, consider a chart designed for signed values instead.

Create the Chart in Excel

Once the data is arranged, use this workflow in Excel for Microsoft 365 on Windows:

  1. Click a cell inside the data range. If the range is not a contiguous table, select the headings and all relevant rows yourself.
  2. Open the Insert tab on the ribbon.
  3. Choose Insert Hierarchy Chart in the Charts area, then select Sunburst.
  4. Review the chart and confirm that the rings follow the intended hierarchy and that the segment sizes look plausible.
  5. Move or resize the chart, then add a useful title and adjust labels or colors as needed.

If the chart command is unavailable, confirm that the selection includes both category columns and numeric values, and check that you are using a version of Excel that supports hierarchy charts. Sunburst charts are available in Excel 2016 and later desktop editions, including Microsoft 365. Ribbon placement and wording can vary slightly between builds. On Mac, use the Insert tab and choose Sunburst from the hierarchy chart options. In Excel for the web, look under Insert and the chart options; if the chart type or a formatting control is not available there, open the workbook in the desktop app.

Read the Rings and Segment Sizes

Start at the center and follow a segment outward to understand the path through the hierarchy. In the example, a viewer can trace North to Furniture to Desk. The outer product segment is part of the Furniture segment, which is part of North. A segment farther out is not an unrelated slice of the whole; it belongs to its parent branch.

Segment size is based on the values supplied in the data. In a standard hierarchy, the size of a parent reflects the combined values of its descendants. If North has 35 units across all its products and South has 25, North receives the larger top-level segment. Within North, Furniture’s share depends on its products’ combined value. The precise visual comparison is strongest among segments at the same level; comparing small outer segments across distant branches can be harder because their positions differ.

Be clear about what the numbers measure. A chart titled Sales by Region and Product is more informative if the reader knows whether values are dollars, orders, or units. If the values are revenue in thousands, say so in the chart title or nearby text. A chart without a clear unit can be visually polished yet misleading.

Format Labels, Colors, and the Title

Click the chart to reveal its chart tabs. Use Chart Design > Add Chart Element to add or adjust elements such as a chart title and data labels. The exact label choices depend on the chart and Excel build; select a label and open Format Data Labels to see the available options. Labels can help identify small categories, but putting every name and value on a dense chart can make it harder to read. A legend or a separate data table may work better when there are many segments.

To change the palette, select Chart Design > Change Colors. Choose colors that distinguish the top-level branches without making the outer ring look like a jumble. Related shades within a branch can help communicate that its outer segments belong together, but do not rely on color alone to communicate essential meaning. Keep the title specific, such as Quarterly Sales by Region and Product, and remove unnecessary visual effects that compete with the data.

Resizing the chart can improve readability, but it cannot solve every overcrowding problem. A larger chart may give labels more room; it will not make dozens of tiny categories easy to compare. If readers need exact values, retain a table alongside the chart or provide a filtered detail view rather than expecting them to estimate every arc.

Fix Common Sunburst Chart Problems

If a chart looks wrong, first inspect the source table rather than repeatedly changing its appearance. Common causes include inconsistent labels, blank hierarchy levels, values stored as text, and subtotal rows mixed with detail rows.

  • The chart has an unexpected ring: Check for an extra category column, a blank heading, or a field that Excel has interpreted as another level. Keep only the hierarchy fields you intend to show and the value field.
  • Segments appear under the wrong group: Verify that each row’s labels form the correct path and that the category columns are in broad-to-specific order. A product listed under the wrong department will be charted there, even if the chart itself is formatted correctly.
  • A group looks too large: Check for duplicate detail rows or parent totals included with child values. Confirm that values use the same unit and that no row has been counted twice.
  • Labels are missing or crowded: Reduce the number of displayed labels, enlarge the chart, or summarize minor categories into a clearly named group. Use the source table for exact figures if the chart cannot display them legibly.
  • New rows do not appear: If the chart uses a fixed range, extend its source data. Converting the source into an Excel table with Insert > Table can make it easier for a chart to include additional rows as the table grows, but check the chart after adding data.

Also check whether a filter or hidden rows are affecting what appears. Chart behavior for hidden or filtered data depends on its settings and version; select the chart and inspect Chart Design > Select Data or the hidden and empty cell options in the Select Data Source dialog if the displayed content does not match the table.

When to Choose Another Chart

Choose a Sunburst when the hierarchy is important and the audience needs to see how detailed categories roll up into larger groups. It is particularly suited to a few clear levels with a manageable number of categories. It can show structure compactly, especially when a long tree would take too much vertical space.

Other charts may answer the question more clearly:

  • Bar chart: Better for ranking values or comparing exact amounts across categories. A horizontal bar chart often handles long labels well.
  • Treemap: Also displays hierarchical part-to-whole data, but uses nested rectangles rather than rings. It can use space efficiently, though comparing shapes and areas can still be difficult.
  • Pie or doughnut chart: Suitable for a small number of categories at one level, but not for showing several levels of detail.
  • PivotTable with a PivotChart: Useful when people need to filter or summarize a large set of records interactively. A PivotTable can also help verify totals before charting.

A common misconception is that a Sunburst chart is always the best way to show multiple categories. More hierarchy does not automatically mean more insight. If the question is which product sold most, a sorted bar chart will usually make the ranking faster to understand. If the question is how each product contributes to a region and department, the Sunburst may be a better fit.

Keep the Chart Useful as Data Changes

Plan for maintenance if the chart will be used in a recurring report. A structured Excel table, clear column headings, and one row per detailed item make future updates more predictable. After adding records, check that the chart includes them, that new labels have not created an unreadable outer ring, and that totals still reconcile with the source report.

For a report shared with people who rely on assistive technology, do not make color the only way to identify groups. Give the chart a descriptive title and provide the underlying figures in an accessible table or accompanying explanation. A visual hierarchy chart is a useful overview, but it is not a substitute for a readable data source when exact values and category relationships matter.

Frequently Asked Questions

How do I add another level to a Sunburst chart in Excel?
Add a new category column in the source data at the appropriate point in the broad-to-specific order, fill it consistently for each detail row, and update the chart’s data range if necessary. Excel uses the additional category field as another ring.

Can a Sunburst chart have only two levels?
Yes. Two category columns create two hierarchy levels, with the first level nearer the center and the second level in the outer ring. You do not need three or more levels to use the chart.

Why are my Sunburst values not adding up the way I expect?
Check that the data contains detail rows only, not both detail values and their parent subtotals. Also verify duplicate rows, numeric values, consistent units, and whether the chart source includes every intended record.

Can I make a Sunburst chart in Excel for the web?
Availability and formatting controls can vary with the web version and account. Check the chart options under Insert. If Sunburst is missing or a control you need is unavailable, open the workbook in Excel for Microsoft 365 desktop or another supported desktop edition.

What is the difference between a Sunburst and a Treemap chart?
Both can show hierarchical part-to-whole data. A Sunburst uses nested rings, while a Treemap uses nested rectangles. Choose based on which layout makes the hierarchy and comparisons clearest for your audience, and use a bar chart when ranking or precise comparison is the main goal.

Related

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.