A Sunburst chart Excel template is a workbook layout with hierarchical category columns and one numeric value column, ready to turn into a chart. In Excel for Microsoft 365 on Windows, arrange each path from broadest category to most specific, select the data, then choose Insert > Insert Hierarchy Chart > Sunburst; Excel builds the chart from the hierarchy.
What a Sunburst Chart Template Contains
Excel does not require a special file type or a built-in Sunburst template. The essential part is a correctly structured data table; once it is set up, you can save a copy as a reusable workbook or make it an Excel template file. The chart is a visual summary of nested categories, such as business unit, department, and team, with a value attached to the most detailed categories.
A practical template has one column for each level of the hierarchy and a final column for the measure being displayed. For example, a staffing chart could use Division, Department, Team, and Headcount. A sales chart might use Region, Product Group, Product, and Sales. Each data row describes one path through the categories and ends with a numeric value.
- Use clear column headers, such as Region, Category, Item, and Sales.
- Repeat parent labels on every row where they apply; do not rely on indentation or merged cells to show the structure.
- Put the value at the end of each leaf-level row, rather than adding separate subtotal rows for parent categories.
- Keep the hierarchy consistent: each column should represent the same level throughout the data.
This structure makes the workbook easier to maintain, filter, review, and reuse for another reporting period.
How Excel Sunburst Charts Work
A Sunburst chart displays the hierarchy as concentric rings. The center represents the top level, and each ring outward represents a more detailed level. A segment is divided into smaller segments when it has child categories. Segment size reflects the associated values, so a larger value occupies more area than a smaller one. Excel aggregates the leaf values to show the combined size of parent categories.
Imagine a company with two divisions, each containing departments and teams. The center can show the company or the highest category Excel infers, the next ring can show divisions, and the outer rings can show departments and teams. The chart is useful when the reader needs to see both the part-to-whole relationship and the path from a total down to its components.
A Sunburst chart is not the same as a list of totals at every level. If you include a department subtotal and also include the values for its teams, those figures may be counted together, making the chart misleading. For a typical template, include values once at the most detailed level and let Excel roll them up.
Prepare Example Data for the Template
Suppose a shop wants to compare sales by region, product group, and product. A simple source table might have the headers Region, Product Group, Product, and Sales. Its rows could include North, Furniture, Desk, 12000; North, Furniture, Chair, 8000; and North, Lighting, Lamp, 5000. The values here are illustrative. A second region would get its own rows, with the relevant region repeated in the first column.
Enter the records as a normal rectangular range: one header row, no blank rows separating groups, and no merged cells. Make sure values such as sales are genuine numbers, not text that merely looks like a number. If the source includes dates, decide first whether the hierarchy should show years, months, or another time grouping; a chart will only reflect the category levels supplied in its source data.
For a reusable workbook, select the range and use Home > Format as Table, then confirm that the table has headers. A table gives the data a consistent structure as records are added. After updating the source, check that the chart’s data range includes the new rows, especially if the chart was created from a fixed range rather than the table.
Create the Chart in Excel for Microsoft 365
- Open the worksheet containing the prepared data. Select the hierarchy columns and the numeric value column, including the headers.
- On the ribbon, choose Insert > Insert Hierarchy Chart > Sunburst. If the chart appears incorrectly, undo the insertion and review the column order and source range.
- Move or resize the chart so its labels and rings are readable. Use the chart’s title area to name the measure and scope, for example “Sales by Region and Product.”
- Use Chart Design > Change Colors to select a suitable palette. To add or adjust labels, use Chart Design > Add Chart Element > Data Labels, then inspect the available label options for the chart.
- Save the workbook with the source table and chart together. To reuse it, replace or append the source records and verify that the chart still points to the intended data.
These ribbon labels apply to Excel for Microsoft 365 on Windows. In Excel for Mac, the chart type and chart design controls are also available, though their placement can vary with the ribbon layout. Excel for the web has a different feature set and interface; if a chart option or formatting control is missing, open the workbook in the desktop app for the full set of controls.
Format the Chart for Clear Reading
Sunburst charts can become crowded when the hierarchy has many categories or long names. The chart may still contain the data, but readers can struggle to identify small segments. Keep the number of levels and categories appropriate to the question. For a presentation, a broad view with a few meaningful levels is often easier to interpret than a chart showing every low-level code.
- Write a specific chart title that identifies the metric and reporting period.
- Use consistent category names and remove unnecessary prefixes that consume label space.
- Choose colors that distinguish groups without implying a ranking that the data does not support.
- Keep the original table nearby or provide a detail view when readers need exact values that labels cannot show clearly.
- Check the chart at the size where it will actually be read, such as a slide or printed page.
Color helps show groups, but segment area is the main quantitative cue. A color change does not mean a value has increased or decreased unless the chart is explicitly designed and explained that way. Avoid relying on color alone to communicate important distinctions, particularly when the workbook will be printed in grayscale or viewed by people with color-vision differences.
Choose or Make a Reusable Template
If you are choosing an existing Excel template, inspect its data structure before entering real records. A polished chart is not enough: check that it has a separate column for each hierarchy level, a numeric measure, and a clear explanation of what each row represents. Remove example values before using the workbook for reporting, and confirm that formulas, chart ranges, and labels do not still refer to sample data.
To make your own reusable version, keep a clean source-data sheet, a chart sheet or dashboard area, and a short instruction note describing the required columns. Consider storing a blank copy separately from each reporting workbook. If you want a native template, use File > Save As and select Excel Template (*.xltx); choose the macro-enabled template format only if the workbook genuinely needs macros. A regular .xlsx file is sufficient for a template that contains data and charts but no VBA.
Templates downloaded from the internet can include formulas, external links, or macros. Use a source you trust, review the workbook before entering sensitive information, and do not enable macros just because a file asks you to. A Sunburst chart itself does not need a macro.
Common Problems and Fixes
If the chart has the wrong rings or labels, first check the order of the hierarchy columns. Put the broadest category first and the most detailed category immediately before the value column. Excel reads the supplied columns as nested levels; it cannot reliably infer a hierarchy from color, indentation, or a separate outline structure.
- Unexpectedly large parent segments: remove subtotal rows if the leaf rows already contain the underlying values. Otherwise the subtotal can be added to the values it summarizes.
- Missing categories: check for blank cells, misspellings, extra spaces, and excluded rows in the selected range. “North” and “North ” can be treated as different labels.
- Values do not scale as expected: verify that the measure is numeric and that the chart includes the complete intended range. Text-formatted numbers may not behave like actual numbers.
- Labels overlap or disappear: simplify category names, reduce the number of displayed levels, enlarge the chart, or use a table alongside it for detail.
- New rows do not appear: review the chart’s source data and extend the range or adjust the table-based source as needed.
Another common misconception is that a Sunburst chart automatically proves a cause or trend. It shows how values are divided among categories at a point in the supplied data; by itself, it does not explain why a segment is large or how values changed over time.
Sunburst Versus Other Excel Charts
A Sunburst chart is a good fit when nested categories and their relative contributions are both important. A Treemap also displays hierarchical proportions, but uses nested rectangles rather than rings; some readers find rectangles easier to compare by area, while Sunburst rings can make the hierarchy’s levels more apparent. Both can become difficult to read when there are many small categories.
Use a bar chart when precise comparisons between a manageable number of categories matter more than showing the full hierarchy. Use a PivotTable or a conventional table when readers need exact figures, sorting, filtering, or a detailed audit trail. You can also pair a Sunburst chart with a table: let the chart provide the overview and the table provide the precise values.
Frequently Asked Questions
Does Excel have a Sunburst chart template?
Excel for Microsoft 365 includes the Sunburst chart type, but a chart type is not the same as a prefilled, ready-made template. Create the hierarchy table and insert the chart, or use a trusted workbook template that already has the structure.
How should I arrange data for a Sunburst chart in Excel?
Put each hierarchy level in its own column, from broadest to most specific, and put one numeric value in the final column. Use one row for each detailed item and repeat its parent categories on that row.
Can a Sunburst chart show percentages?
Segment sizes communicate relative proportions, but the available label settings depend on the chart and Excel version. If you need exact percentages, calculate or display them in a companion table and make clear what total they use.
Why does my Sunburst chart show the wrong totals?
Look for subtotal rows mixed with detail rows, duplicate records, text instead of numeric values, or an incomplete source range. A common fix is to retain only the leaf-level values and let Excel aggregate them into parent categories.
Can I use a Sunburst chart in Excel for Mac?
Excel for Mac includes hierarchy chart options in supported versions, including Sunburst. Ribbon placement and some controls can differ from Windows; if a control is not visible, check the chart design tabs or open the workbook in the desktop version available to you.
Related
- Compare Two Excel Spreadsheets Quickly: Best Methods
- Shade Every Other Row in Excel: Quick, Reliable Methods
- Quick Way to Shade Every Other Row in Excel Automatically
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- How to Flip an Axis in an Excel Chart: Step-by-Step GuideTo flip an axis in an Excel chart, select the axis, right-click it, choose Format Axis, and turn…
- Circle Bullet Chart in Excel: A Step-by-Step GuideCreate a circle bullet chart in Excel by plotting an actual value and the unused portion of a…
- Excel Dashboard Software Examples: Tools, Uses, and LimitsExamples of software used to create dashboards from Excel data include Microsoft Excel, Microsoft Power BI, Tableau, Qlik…
- Excel Half-Moon Chart: Add Red, Yellow, and Green ZonesTo create a red, yellow, and green half-moon chart in Excel, make a doughnut chart from three equal…
- Excel Histogram: How to Show PercentagesExcel’s built-in Histogram chart shows frequency—the number of observations in each bin—not a normalized percentage option. To show…
- Relative Frequency Histogram in Excel: Steps and FormulasTo make a relative frequency histogram in Excel, create bins, count how many observations fall in each bin,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.