How to Create and Customise Sunburst Charts in Microsoft Excel for Hierarchical Data

Visualising multi-tiered categorical data such as company organisational hierarchies, multi-level product revenue streams, or departmental budget breakdowns can be challenging when using traditional flat pie or bar charts. Microsoft Excel features native Sunburst charts designed specifically to plot concentric rings of hierarchical data. Each ring corresponds to a tier in the data hierarchy, with the innermost circle representing parent categories and outer concentric rings illustrating proportional sub-category breakdowns.

Anatomy of an Excel Sunburst Chart

Understanding how Excel structures Sunburst charts helps you prepare datasets effectively and explain chart findings to stakeholders:

• The Centre Circle: The central core represents the top-level parent categories (for example, Regions or Business Divisions).
• Concentric Rings: Each outward layer of concentric rings represents a deeper subsidiary tier (for example, Countries > Cities > Product lines).
• Angular Slices: The arc length and angular proportion of each slice correspond directly to its relative numerical value compared to sibling items within the same parent node.
• Slice Grouping: Sub-items are neatly clustered alongside their corresponding parent slice, maintaining clear visual lineage without confusing cross-category overlaps.

Structuring Hierarchical Source Data in Excel

For Excel to generate a Sunburst chart without errors, arrange your source data in hierarchical columns ordered from highest to lowest level, concluding with the numeric values in the rightmost column. For example:

| Level 1 (Region) | Level 2 (Country) | Level 3 (City) | Sales Value |
|------------------|-------------------|----------------|-------------|
| Europe           | UK                | London         | 45000       |
| Europe           | UK                | Manchester     | 22000       |
| Europe           | France            | Paris          | 38000       |
| Europe           | France            | Lyon           | 19000       |
| North America    | USA               | New York       | 62000       |
| North America    | USA               | Chicago        | 34000       |
| North America    | Canada            | Toronto        | 28000       |

Ensure parent cells are repeated in their respective rows so Excel establishes parent-child lineages seamlessly.

Inserting a Sunburst Chart in Excel

Generating the chart takes just a few clicks:

1. Highlight your complete hierarchical data range, including all column headers and values.
2. Click the Insert tab on the Excel ribbon.
3. In the Charts section, click the Insert Hierarchy Chart icon (represented by branching square boxes).
4. Under the Hierarchy category, select Sunburst.

Excel immediately plots a multi-tiered Sunburst diagram directly onto your spreadsheet, assigning distinct colour bands to each top-level root category.

Customising Sunburst Formatting and Labels

To maximise visual impact and readability, fine-tune the chart formatting options:

1. Right-click any slice within the chart and choose Format Data Series.
2. In the side formatting pane, adjust data label positions:
   • By default, labels rotate to follow the curvature of each concentric slice. If category titles appear truncated, you can resize the overall chart frame or enlarge specific outer rings.
3. To display both category names and precise numerical values, click the green + Chart Elements icon, hover over Data Labels, click the arrow, and select More Data Label Options. Mark both Category Name and Value.
4. Navigate to the Chart Design tab on the ribbon and click Change Colors to apply an elegant corporate palette that differentiates root branches clearly.

When to Choose Sunburst vs Treemap Charts

While both Sunburst and Treemap charts visualise hierarchical structures, their graphical representations serve distinct purposes:

• Choose Sunburst: When you need to clearly emphasise the multi-level depth of the hierarchy and how sub-categories radiate outwards from root origins.
• Choose Treemap: When comparing nested rectangle areas is preferred for dense datasets with deeply nested leaf nodes where circular ring real estate becomes cramped.

Leveraging Sunburst charts in Microsoft Excel equips financial controllers, market researchers, and team leads to present complex multi-level datasets with immediate visual elegance and analytical rigor.