A sunburst chart in PowerPoint displays hierarchical data in a circular layout. Each ring represents a level in the hierarchy, with the innermost ring as the top level. This chart type is useful for showing proportions across categories and subcategories at a glance. This article explains how to create, customize, and avoid common mistakes when building a sunburst chart in PowerPoint.
Key Takeaways: Creating a Sunburst Chart in PowerPoint
- Insert > Chart > Sunburst: Opens the default sunburst chart template with sample data in Excel.
- Data layout in Excel: Each column represents a hierarchy level, and rows contain the items and values for that level.
- Chart Design > Change Chart Type: Lets you switch a selected chart to a sunburst chart without rebuilding the data.
What a Sunburst Chart Shows and When to Use It
A sunburst chart uses concentric rings to represent hierarchical data. The innermost ring is the top level of the hierarchy. Moving outward, each ring shows subcategories of the previous ring. The size of each segment corresponds to its value relative to the whole.
This chart works best when you have three or more levels of hierarchical data. Common use cases include company organizational structures, product category breakdowns, budget allocations, and geographic sales distributions. The chart requires a flat table of data, not a nested outline.
PowerPoint uses Microsoft Excel to store the data for the chart. You do not need Excel installed separately to create the chart. PowerPoint opens a small Excel window inside the application for data entry.
Data Structure Requirements
The data must be arranged in columns. The first column contains the top-level categories. The second column contains the next level, and so on. The final column contains the numeric values. Each row represents one data point at the deepest level. Empty cells in a row cause PowerPoint to treat that branch as incomplete.
Steps to Insert and Populate a Sunburst Chart
- Open the Insert Chart dialog
Go to the ribbon and click Insert. In the Illustrations group, click Chart. The Insert Chart dialog opens. - Select the Sunburst chart type
In the left pane of the Insert Chart dialog, click All Charts. Scroll down or click the Hierarchy category. Select Sunburst from the list. Click OK. - Replace the sample data in Excel
PowerPoint inserts a default sunburst chart and opens a small Excel window with sample data. The sample data has three columns: Category, Subcategory, and Value. Delete the sample data and paste or type your own data in the same column layout. - Close the Excel window
After entering your data, click the X button on the Excel window. The chart updates automatically in PowerPoint. - Resize and position the chart
Click and drag the corner handles of the chart to resize it. Drag the chart to the desired position on the slide.
Customizing the Sunburst Chart Appearance
After inserting the chart, you can change colors, labels, and other visual elements.
Change Colors and Styles
- Select the chart
Click the chart to activate the Chart Design and Format tabs on the ribbon. - Apply a built-in style
On the Chart Design tab, browse the Chart Styles gallery. Click a style to apply it. Hover over a style to preview it. - Change individual segment colors
Click a single segment once to select the entire ring. Click the segment again to select only that piece. Right-click the selected segment and choose Fill. Pick a color from the palette.
Add Data Labels
- Select the chart
Click the chart to make the Chart Elements button appear next to the chart border. - Enable data labels
Click the Chart Elements button. Check the Data Labels box. By default, PowerPoint shows the value for each segment. - Change label content
Right-click any data label and choose Format Data Labels. In the Format Data Labels pane, check or uncheck options such as Category Name, Value, Percentage, or Series Name.
Adjust the Chart Title
- Click the chart title
The default title is Chart Title. Click it to select the text box. - Type a new title
Replace the placeholder text with your own title. Press Enter to confirm.
Common Mistakes and Limitations of Sunburst Charts
Data With Missing Hierarchy Levels Causes Gaps
If a row has a value in the third column but the second column is blank, PowerPoint does not know where to place that value. The chart may show a blank ring or misaligned segments. Fill every cell in the hierarchy columns. Use a placeholder label such as Other if a subcategory does not have a name.
Too Many Levels Make the Chart Unreadable
Sunburst charts with more than five rings are difficult to read. The outer rings become very thin. Limit your data to four or five hierarchy levels. If you need more levels, consider using a treemap chart or a drill-down approach with multiple slides.
Negative Values Are Not Supported
Sunburst charts only display positive numeric values. If your data contains negative numbers, the chart will not render those segments. Remove or adjust negative values before inserting the chart. Use absolute values or a different chart type like a bar chart for data with negatives.
Chart Does Not Update After Changing Data in the Sheet
If you edit the linked Excel data after closing the Excel window, the chart may not refresh. Right-click the chart and select Edit Data. The Excel window opens again. Make your changes and close the window. The chart updates immediately.
Cannot Convert a Sunburst Chart to a Different Type Without Losing Data
PowerPoint allows changing a chart type after creation. Right-click the chart and select Change Chart Type. However, if you switch to a non-hierarchical chart type, the data layout may break. Always keep a copy of your original data before changing the chart type.
Sunburst Chart vs Treemap Chart in PowerPoint
| Item | Sunburst Chart | Treemap Chart |
|---|---|---|
| Layout | Circular rings from center outward | Rectangular tiles nested inside a larger rectangle |
| Best for | Showing hierarchy with a clear top-level center | Comparing proportions when space is limited |
| Readability with many items | Outer rings become thin and hard to read | Small tiles cluster and overlap labels |
| Data label placement | Labels may overlap in narrow segments | Labels fit inside tiles more easily |
| PowerPoint insertion path | Insert > Chart > Hierarchy > Sunburst | Insert > Chart > Hierarchy > Treemap |
A sunburst chart emphasizes the central top-level category and shows relationships across rings. A treemap chart uses space more efficiently and is better for datasets with many items at the same level. Choose sunburst when you want to show the flow from a single root outward. Choose treemap when you need to pack many categories into a small area.
To create a sunburst chart in PowerPoint, prepare your data in columns with each hierarchy level in its own column. Insert the chart from the Hierarchy category, paste your data into the Excel sheet, and customize colors and labels. Avoid missing hierarchy cells, negative values, and more than five levels. Use the Edit Data option to refresh the chart after changing the source data. For large datasets with many subcategories, consider a treemap chart as an alternative.