Does Excel Have a Sunburst Chart? How to Make One

Charts & pivot tables · Updated November 19, 2026

Yes, Microsoft Excel has a built-in Sunburst chart for showing hierarchical data, such as departments divided into teams or product groups divided into categories. In Excel for Microsoft 365 on Windows, select the data and choose Insert > Insert Hierarchy Chart > Sunburst.

What a Sunburst Chart Shows

A Sunburst chart turns a hierarchy into nested rings. The innermost ring represents the highest level, and each ring farther out represents a lower level of detail. A slice is divided into smaller slices when its category has children. For instance, a company might appear at the center, its departments in the next ring, and teams within those departments in the outer ring.

The chart uses slice area to communicate the values associated with the categories. A large branch represents a larger share of the total than a small branch. This makes a Sunburst useful for showing both how a total is divided and where its subcategories belong. The relationships are the point: it is not simply a pie chart with extra decoration.

Sunburst charts are best suited to a few clearly defined levels and categories with meaningful numeric values. They are less useful when readers need to compare many similar-sized slices precisely, since angles and areas in a ring are harder to compare than aligned bars. They also do not show change over time unless you make separate charts or otherwise provide a time-based comparison.

How to Arrange the Source Data

Put each level of the hierarchy in its own column, from broadest to most specific, and put the measure to chart in the final column. Use one row for each lowest-level category or observation. Include a heading in each column so Excel can identify the fields. For example:

  • Department: Sales; Team: Online; Product: Headphones; Revenue: 120
  • Department: Sales; Team: Online; Product: Speakers; Revenue: 80
  • Department: Sales; Team: Stores; Product: Headphones; Revenue: 150
  • Department: Support; Team: Service Desk; Product: Returns; Revenue: 50

Here, Department is the first level, Team is the second, Product is the third, and Revenue supplies the values. Repeating a parent name on separate rows is normal: each row traces a path from its parent categories down to a leaf category. Excel can use those repeated paths to build the nested branches.

Use consistent labels and avoid blank hierarchy cells within the data. A blank can make it unclear which parent a lower-level value belongs to, while inconsistent spelling can split what should be one category into separate branches. Make sure the final column contains numbers, not values stored as text. If your data is already summarized at a higher level, decide whether you need to include the detail rows as well; mixing totals and their component values can count the same amount twice.

Create a Sunburst Chart in Excel for Windows

  1. Arrange the hierarchy columns and numeric value column as described above, with headers in the first row.
  2. Select the full range, including the headers. If the data is in an Excel table, select a cell in the table; selecting the intended data range explicitly is a useful way to avoid including unrelated columns.
  3. On the ribbon, choose Insert > Insert Hierarchy Chart > Sunburst. Excel inserts the chart into the worksheet.
  4. Check that the ring order and category names make sense. If the chart does not reflect the intended levels, review the source columns and the selected range.
  5. With the chart selected, use Chart Design to add or change the title, labels, colors, or other available chart elements.

If you do not see the hierarchy-chart button, look in the Charts area of the Insert tab and open its chart-type menu. The exact appearance of the ribbon can vary with window size and Excel updates. Sunburst is a built-in chart type in Excel 2016 and later desktop versions, including Microsoft 365; it is not necessary to install an add-in for the standard chart.

Read the Rings and Format the Chart

Read the rings from the center outward. Each outer slice belongs to the slice immediately inside it, so a segment is understood through both its own label and its parent branch. The angle around the circle is not a sequence or ranking. It is primarily a way to lay out the hierarchy, and the chart can be harder to interpret when there are many narrow segments.

A useful chart title says what the values measure and, where needed, the period covered. For example, “Revenue by Department, Team, and Product” is more informative than “Sunburst.” To add a title, select the chart and choose Chart Design > Add Chart Element > Chart Title. To add data labels, choose Chart Design > Add Chart Element > Data Labels, then review the available label settings for the information you want to display.

Labels can quickly crowd a chart with many categories. Try displaying only the most useful category names or values, and make the chart larger if labels overlap. A legend may help identify colors, but colors alone should not be expected to communicate the hierarchy: readers still need category labels and the ring structure. If you change the source data after creating the chart, Excel generally updates the plotted data when it is within the chart’s source range.

Example: Exploring a Sales Hierarchy

Suppose a retailer wants to see how sales are distributed across regions, product categories, and individual products. The source could have columns for Region, Category, Product, and Sales. A row for North, Audio, Headphones, and 120 represents one leaf in the hierarchy. A second row for North, Audio, Speakers, and 80 adds another leaf under the same region and category.

The resulting Sunburst places regions in the center ring, categories in the next ring, and products on the outside. The Audio branch in North includes both products, and its overall size reflects their combined contribution when the chart is based on the leaf-level sales rows. A reader can quickly see which region or category accounts for a larger share, then follow its outer slices to see the detail.

This view does not make exact comparisons effortless. If the question is “Which product sold 120 units and which sold 125?”, a sorted bar chart with visible values is usually clearer. Sunburst is stronger when the question is “How does the total break down through several levels?” Use labels or a companion table when readers need exact figures.

Common Problems and How to Fix Them

  • The chart has the wrong levels: Check that the columns are ordered from parent to child and that the selected range includes only the intended hierarchy and value fields.
  • Categories appear as separate branches: Look for spelling differences, extra spaces, or inconsistent naming. “Online” and “Online ” can be treated as different text entries.
  • The chart is blank or has missing slices: Confirm that the value column contains numeric data and that the source range includes it. Zero values have no visible area, and negative values do not make a meaningful part-to-whole slice.
  • There are too many tiny segments: Summarize or filter low-level categories, or use a different chart for detailed comparisons. Combining unrelated items into a single “Other” category can help only when that grouping is honest and useful.
  • Totals seem inflated: Do not place a parent subtotal alongside its child detail as if both were independent leaves. For example, including a category total of 200 and its two product values of 120 and 80 can make the chart count the same sales twice.

When a chart remains confusing, inspect the source table before adjusting colors. Most hierarchy problems come from the data structure, not the chart’s appearance. A small test range with just a few branches can help identify whether the issue is the layout or the full dataset.

Sunburst Compared with Treemap and Other Charts

Excel also offers a Treemap chart for hierarchical data. A Treemap represents categories as nested rectangles rather than rings. It can use worksheet space efficiently and can be easier to label when there are many branches, while Sunburst makes parent-child paths visually explicit through its rings. Neither is automatically best: choose based on whether the audience benefits more from seeing nested boxes or following circular levels.

A pie or doughnut chart is suited to a single level of categories, not a multi-level hierarchy. A bar chart is usually a better choice when precise ranking or comparison matters, especially with many categories. A Sunburst can answer a structural question well, but it is not a substitute for every chart that shows parts of a whole.

Excel Versions and Platform Notes

The instructions above are for Excel for Microsoft 365 on Windows. Sunburst is available in desktop Excel 2016 and later, including current Microsoft 365 editions. In current Excel for Mac, the chart type is also available; use the Insert tab’s hierarchy-chart options, noting that ribbon labels or placement may differ from Windows.

Excel for the web can have different chart-creation and formatting options from the desktop application. If Sunburst is not offered in the web app’s Insert chart controls, open the workbook in desktop Excel to create or fully edit the chart. A chart already in a workbook may display differently depending on the app and its supported features, so check the finished workbook in the environment where it will be used.

Frequently Asked Questions

Does Excel have a Sunburst chart?
Yes. Excel 2016 and later desktop versions, including Microsoft 365, include a built-in Sunburst chart for hierarchical data.

How do I insert a Sunburst chart in Excel?
Select the data range with hierarchy columns and a numeric value column, then choose Insert > Insert Hierarchy Chart > Sunburst in Excel for Microsoft 365 on Windows.

What data is needed for a Sunburst chart?
Use one column for each hierarchy level, ordered from parent to child, followed by a numeric measure. Each row should describe a path to a lowest-level category or observation.

Can a Sunburst chart show percentages?
It can communicate relative shares through slice sizes, and its available data-label settings may show values or percentages. Check the label options in your Excel version and include labels only when they remain readable.

What is the difference between a Sunburst and a Treemap?
Both show hierarchical data. Sunburst uses concentric rings to emphasize levels and paths; Treemap uses nested rectangles and can make more efficient use of space for some datasets.

Why are some Sunburst slices missing?
Check for zero or nonnumeric values, blanks in the hierarchy, and an incorrectly selected source range. Zero values have no area to display, while negative numbers are not appropriate for a part-to-whole Sunburst chart.

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.