How to Create a Sunburst Chart in Excel: Step-by-Step

Charts & pivot tables · Updated November 20, 2026

To create a Sunburst chart in Microsoft Excel for Microsoft 365, arrange your data in columns from the broadest category to the most specific category, with a numeric value in the last column. Select the table, then choose Insert > Insert Hierarchy Chart > Sunburst. Excel turns the category levels into rings, with the outer segments showing the most detailed categories.

What You’ll Need

  • Excel for Microsoft 365 on Windows. Sunburst charts are also available in many desktop editions of Excel, including recent Mac versions, though the ribbon layout can vary. If the chart type is missing in Excel for the web, open the workbook in the desktop app.
  • A small, rectangular table with one column for each level of the hierarchy and one final column containing numeric values.
  • One row for each lowest-level item you want represented. For example, a row might identify North America, Accessories, and Headphones, followed by the revenue for Headphones.

Step-by-Step

  1. Plan the category hierarchy. Decide what each ring should represent, moving from general to specific. For a sales chart, you could use Region, Product Category, Product, and Revenue. Region becomes the innermost ring, Product Category the next ring, and Product the outermost category ring. The final numeric column determines the segment sizes; it is not a category ring.
  2. Put the data into columns. Create a header row, then enter a complete path for each lowest-level item. For example, use columns named Region, Category, Product, and Revenue. Repeat parent labels on each applicable row: if three products belong to Accessories in North America, all three rows should show North America and Accessories. Excel uses the values in those columns to group the leaf items under their parent categories.
  3. Check the values and the table structure. Make sure the final column contains numbers, not amounts stored as text. Remove blank rows, merged cells, and any grand-total rows from the selected source. For a straightforward chart, use nonnegative values and give each leaf item one value. Parent totals should not be entered as extra rows alongside the leaf values, because those totals can be counted in addition to the items they summarize.
  4. Select the entire source range. Include the headers and all category and value rows, but exclude notes or totals beneath the table. If the range is a formatted Excel table, click a cell in the table and confirm that the chart includes all relevant table columns. Selecting the data first makes it easier for Excel to identify the category levels and the values column correctly.
  5. Insert the Sunburst chart. On the Windows ribbon, select Insert > Insert Hierarchy Chart > Sunburst. In some ribbon layouts, the hierarchy-chart button is shown as a chart icon, so open its menu and choose Sunburst. Excel creates the chart using the selected range. If the command is unavailable, check that you are using a supported desktop version and that you selected a suitable range with category columns and numeric values.
  6. Check that the rings follow the intended order. Read from the center outward: the first category column should be at the center, and each later category column should form the next ring. The numeric values determine the area of the segments. If the ring order or labels look wrong, verify the order of your source columns and confirm the value field is last; then select the corrected range and insert the chart again.
  7. Add a useful title and labels. Click the chart title and replace it with a concise description, such as Sales by Region and Product. To add or adjust labels, select the chart and use Chart Design > Add Chart Element > Data Labels, then choose a placement offered by Excel. The available label placements can depend on the chart and the space available. Avoid displaying every level and every value if the result becomes crowded; the legend, ring position, or a shorter category name may communicate the hierarchy more clearly.
  8. Format and save the chart. Use Chart Design to choose a chart style or color palette, and use the Format tab to adjust selected chart elements. Click a segment to select it; selecting a segment again may select an individual data point rather than the entire series. Keep neighboring categories distinguishable and use a restrained palette so readers can follow the rings. Resize the chart to give labels room, then save the workbook.

For example, a table with Region, Category, Product, and Revenue columns can show each product as a segment in the outer ring. Excel groups those segments into category sections, then groups the categories into regions. If one product has higher revenue than another, its segment occupies more of the chart, making the display useful for comparing each item’s contribution within the hierarchy. It is not a time-series chart: dates or months generally need to be treated as categories, not as a continuous timeline.

Common Mistakes

  • Using a wide report instead of a hierarchy list. A cross-tab with categories across columns may not give Excel a clear set of parent-child levels. Reshape it so each row contains the full path and the associated value.
  • Including subtotal rows. A row labeled Total or Accessories Total can be interpreted as another item. If the individual product values are already included, adding their subtotal as another value exaggerates that category’s share. Select the leaf rows only.
  • Leaving parent names out of lower-level rows. If the same product name appears under different categories, its parent columns identify which branch it belongs to. Repeat the full path on every row instead of relying on nearby cells or visual indentation.
  • Expecting equal-sized segments. Segment size reflects the numeric values, not the number of labels. A category with a large value can dominate the visual, even when it contains only one item.
  • Adding too many levels or labels. A deep hierarchy with many small segments can become difficult to read. More rings do not automatically make the chart more informative; simplify the source or remove nonessential labels if the chart is crowded.

Tips

  • Keep each category level consistent. Use a clear, stable definition for each column. For instance, do not mix product families and individual products in the same Category column unless that is intentional.
  • Use distinctive names. Short, unique labels are easier to read. If a label is repeated in different branches, its position in the rings provides context, but distinct names can still reduce confusion in a legend or data label.
  • Sort the source data thoughtfully. Sorting by parent categories and then by a relevant name can make the source easier to review. It does not change the underlying totals, but it can make it simpler to spot missing paths and duplicated rows.
  • Choose labels for the question you want to answer. Category names help readers identify branches; values help them compare contribution. Showing both can be useful for a small chart, but too many labels can overlap or become unreadable.
  • Keep a clean source table. If the chart should update as rows are added, format the source range as an Excel table before inserting the chart. Review the chart after adding data to make sure the new rows are included and the hierarchy remains consistent.
  • Consider whether another chart is clearer. Sunburst works best when the hierarchy and part-to-whole relationships matter. If the goal is precise comparison between many similarly sized values, a bar chart may be easier to read.

Troubleshooting

  • The Sunburst option is missing. Confirm that you are using a desktop Excel version that supports hierarchy charts, and select a data range with multiple category columns and a numeric values column. In Excel for the web, chart options can differ; try opening the workbook in Excel for Microsoft 365 on Windows or a supported desktop Mac version.
  • The chart has only one ring or the hierarchy looks flat. Check whether the selected range includes each category column. Ensure that the category levels are in separate columns, in broad-to-specific order, and that the final column contains the numeric values. Reinsert the chart after selecting the complete range.
  • Values appear as labels or segment sizes look implausible. Look for a misplaced column, text-formatted numbers, blank or invalid entries, and totals included as ordinary rows. Confirm that the last selected column is the intended measure and that each leaf item’s value is recorded once.
  • Some names or segments are missing. Check the source for blank category cells, misspelled parent names, filtered-out rows, or a selection that stops before the final records. Fill in the correct category path on each row, clear filters if needed, and update or recreate the chart using the full range.
  • Labels overlap or are hard to read. Make the chart larger, shorten long source labels, reduce the number of displayed data labels, or show labels only for a more useful level. If the chart remains cluttered, group minor items into a meaningful category or choose a bar chart instead.

Frequently Asked Questions

What data format does an Excel Sunburst chart need?
Use one column for each level of the hierarchy, followed by a numeric value column. Each data row should identify a lowest-level item and repeat its parent categories.

Which column appears in the center?
The first category column in the selected data appears in the innermost ring. Each category column after it appears farther outward, while the final numeric column controls segment size.

Can I create a Sunburst chart with just one category column?
A Sunburst is intended to show hierarchical levels. With only one category field, it cannot show meaningful parent-child rings. Add at least one additional category level, or choose a chart type suited to a single set of categories.

Can I show totals in the center or in parent segments?
Excel derives parent segments from the values of their child items. Do not add parent totals as extra rows when their children are already included, because doing so can double-count the amounts.

Can I make a Sunburst chart in Excel for Mac?
Recent desktop versions of Excel for Mac support Sunburst charts. Select the data and look for Sunburst in the hierarchy chart options on the Insert tab; the command placement may differ slightly from Windows.

How do I update a Sunburst chart after changing the data?
If you edit values in the chart’s source range, Excel generally updates the chart. If you add rows beyond a normal selected range, expand the chart’s source data or use an Excel table as the source so new rows can be included.

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.