Excel does not have a chart type named Sunburst Pie: it has a Sunburst chart, which resembles a pie but displays several levels of a hierarchy as concentric rings. In Microsoft Excel for Microsoft 365 on Windows, select a properly arranged hierarchy-and-values range, then choose Insert > Insert Hierarchy Chart > Sunburst.
What an Excel Sunburst Chart Shows
A standard pie chart divides one circle into slices to compare parts of a single whole. A Sunburst chart adds levels: the center represents the top category, and each ring moving outward represents a deeper category or subgroup. The outermost ring contains the most detailed categories in the selected data.
For example, a company could organize sales by Region, Product Type, Product, and Sales. The inner ring can show regions; the next ring divides each region into product types; the next divides those into individual products. Segment sizes represent the numeric values, such as sales. A large parent segment therefore contains the combined value of its smaller child segments.
The term pie chart is understandable because the chart is circular and uses slices, but it is not simply a pie chart with decoration. Its purpose is to show both part-to-whole proportions and parent-child relationships. That extra hierarchy is useful only when the levels are meaningful and the chart remains readable.
How the Rings and Values Work
Each row of the source data describes a path through the hierarchy and ends with a numeric measure. Excel reads the category columns as successive levels and uses the final numeric column to size the segments. The first category column becomes the innermost level, while later category columns appear farther from the center.
Suppose the data has columns for Region, Department, Item, and Revenue. A row such as West, Furniture, Desk, 4200 describes one path: West contains Furniture, which contains Desk, with a revenue value of 4,200. Rows with the same upper-level categories contribute to their shared parent portions of the chart. The chart is most dependable when each intended leaf category has a clear path and an appropriate value.
The proportions are relative to the total represented by the chart. A segment’s angular span reflects its share of the relevant parent total; it is not a separate independent percentage at every level. If one region is much larger than another, the region segment will be larger, and its child segments divide that region’s portion according to their values.
Prepare the Source Data
Organize the data as a simple rectangular range, with one hierarchy level per category column and the measure in the last column. Include a header for every column. Avoid merged cells, blank rows within the range, subtotals mixed into the detail rows, and descriptive text in the value column. Those structures can make Excel interpret the data incorrectly or create confusing segments.
- Use a consistent order for category levels, such as Region, Department, Product, then Sales.
- Put a numeric value in the final column. Check that values intended as numbers have not been stored as text.
- Repeat parent names on detail rows rather than leaving cells blank beneath the first occurrence.
- Use consistent category spelling. For example, North and N. should not both represent the same region unless they are meant to be separate categories.
- Remove subtotal and grand-total rows from the detail range so they are not counted alongside the underlying records.
For instance, a compact source table might contain East, Electronics, Camera, 1800; East, Electronics, Headphones, 900; and East, Home, Lamp, 600. Each row supplies a full category path and a value. Before charting a large export, consider summarizing it to one value per intended leaf path. That makes it easier to check totals and prevents duplicate records from accidentally inflating a segment.
Create the Chart in Excel for Microsoft 365
- Arrange the headers, category levels, and numeric values as described above, then select the complete range, including its headers.
- On the Windows ribbon, choose Insert > Insert Hierarchy Chart > Sunburst. The chart is inserted on the worksheet.
- Check the ring order and segment values against the source. The first category field should form the inner ring, and the final category field should form the outer detail.
- Use the chart tabs to refine the result. Chart Design offers chart styles and chart-element controls; Format provides options for selected chart elements.
- Add a descriptive title and, if useful, data labels. Keep the source table available so readers can confirm exact values.
If the chart does not look right, first check whether the selected range includes every category column and the value column, and whether the values are numeric. A chart made from only the first category and value columns cannot show the additional hierarchy levels. To change the chart’s source range, select the chart and use Chart Design > Select Data, then revise the data range.
In Excel for Mac, select the range and look on the Insert tab for the hierarchy chart options, then choose Sunburst. Ribbon wording and placement can differ somewhat by Excel release. Excel for the web may have a different set of chart editing controls; if a needed hierarchy-chart option is missing, open the workbook in the desktop app.
Read and Format the Chart
Begin at the center and move outward, following the category sequence in the source columns. A segment’s color and position identify its branch, while its size communicates the value relative to the rest of its parent level. Do not infer exact amounts from area alone; labels or the source data are better for precise comparisons.
Data labels can make small charts easier to interpret, but labeling every segment in a deep hierarchy often creates clutter. Select the chart and use Chart Design > Add Chart Element > Data Labels to explore the available label placement options. Depending on the chart and Excel build, the label settings can expose details such as category names or values. Review the result rather than assuming every option is available or legible for every segment.
Use a clear title such as Regional Sales by Product. Choose colors that distinguish related groups without implying an unintended ranking. If the chart contains many small outer slices, increase the chart area, reduce the number of displayed categories, or report the smallest items in a table. A legend may help explain color, but it does not replace a clear hierarchy and readable labels.
Common Problems and How to Fix Them
- The chart has only one or two rings: Confirm that the selection includes all category columns. A missing intermediate field cannot appear as a ring.
- Unexpected categories appear: Look for blank cells, inconsistent names, or totals included among the detail records. Clean the source and update the chart’s range.
- Values seem too large: Check for duplicate source rows, repeated transactions, or subtotal rows. Excel charts what the selected data supplies; it cannot determine whether repeated records are accidental.
- Labels are crowded: Reduce label detail, enlarge the chart, or simplify the hierarchy. A chart with many tiny segments may not be an effective way to show every item.
- The segments do not communicate a useful comparison: Consider whether the values are comparable and whether the category paths are consistent. A hierarchy chart cannot repair misleading or incomplete input data.
One common misconception is that every ring is a separate pie chart with an independently calculated total. The rings are connected: child values belong to parent categories, and a parent segment represents the values beneath it. Another is that a Sunburst chart automatically explains the data. It visualizes the structure supplied, but a title, consistent categories, and a source table may still be needed to give the viewer context.
Sunburst Versus Pie, Doughnut, and Treemap
Choose a regular pie chart when the question is simply how a small number of categories divide one total. It is easier to read than a Sunburst when there is no parent-child structure. A doughnut chart also shows one set of categories as a ring; adding rings can display multiple series, but those rings do not automatically encode a nested category hierarchy in the same way as a Sunburst.
A Treemap is another Excel hierarchy chart. It uses nested rectangles rather than rings, which can make efficient use of a rectangular area and provide room for labels. A Sunburst emphasizes the path from the center to the outside and can make the hierarchy feel more explicit, but small outer slices are hard to compare. A Treemap may be preferable when there are many categories or the available page space is rectangular.
For precise comparisons across categories, a sorted bar chart is often clearer than either circular hierarchy chart. If the key question is change over time, use a line chart or another time-series display rather than trying to encode dates as nested rings. Select the chart type that answers the reader’s question, not merely the one that looks most distinctive.
When a Sunburst Is a Good Choice
A Sunburst works best when the data has a genuine hierarchy, values are nonnegative parts of a whole, and the audience needs an overview of how large groups break down. Useful examples include expenses by category and subcategory, website visits by section and page, or inventory by department, product family, and item. It can also help reveal whether one parent category dominates or whether its value is spread across many children.
It is less suitable when readers must compare many values precisely, when there are numerous levels, or when labels are long. Negative values do not fit the usual part-to-whole reading of segment size. For mixed positive and negative measures or a hierarchy with very uneven scales, use a different visualization or explain the limits clearly. In a report, pair the chart with a table when exact figures matter.
Frequently Asked Questions
Is a Sunburst chart the same as a pie chart?
A Sunburst is a hierarchical chart that uses circular slices arranged in rings. A pie chart shows one level of categories, while a Sunburst can show several nested levels.
How do I make a Sunburst chart in Excel?
Put hierarchy fields in separate columns and the numeric measure in the final column. Select the range, then choose Insert > Insert Hierarchy Chart > Sunburst in Excel for Microsoft 365 on Windows.
Why is my Excel Sunburst chart showing the wrong number of rings?
Each category column in the selected data represents a hierarchy level. Include all intended category columns, in the correct order, and check that the selection includes the header and numeric value column.
Can I use negative numbers in a Sunburst chart?
Sunburst charts are designed to show parts of a whole through segment sizes, so negative values are not a natural fit for their interpretation. Use a chart suited to positive and negative comparisons, such as a bar chart, when signs matter.
Should I use Sunburst or Treemap in Excel?
Use Sunburst when the center-to-outside hierarchy is useful and the slices remain readable. Try Treemap when nested rectangles use the available space more effectively, or use a bar chart when exact comparisons are the priority.
Related
- Excel Shortcut to Insert Another Row in Windows and Mac
- Excel Shortcut to Select to the End of a Column
- Excel Shortcut to Select Cells to the End of a Column
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Power Pivot Data Model: How Excel Connects Your DataA Power Pivot data model is an Excel workbook’s collection of related tables, calculations, and connections, stored together…
- Org Chart in PowerPoint: Best Ways to Build OneFor most teams, the best way to make an org chart in PowerPoint is to use SmartArt: choose…
- Excel Pivot Table: How to Ignore Blank Rows and ValuesYes. In Excel for Microsoft 365 on Windows, open the pivot field’s drop-down and clear the (blank) item…
- Bubble Chart in Google Sheets: Setup and TipsYes—Google Sheets can make bubble charts in a web browser. Arrange each item in a row with five…
- Multi-Year Gantt Chart Template in Excel: Build a PlanYes. You can build a multi-year Gantt chart template in Excel by listing tasks and their start and…
- Excel Histogram: Why It Can Feel So FrustratingYes, Excel’s histogram can feel frustrating when it chooses unhelpful bins, hides important settings, or produces a chart…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.