How to Create and Format a Sunburst Chart in Microsoft Excel to Visualise Hierarchical Data

Presenting hierarchical data—such as departmental organizational structures, corporate sales by continent, country, and product, or multi-tiered project budgets—using traditional stacked bar charts or standard pie charts quickly results in visual clutter and unreadable legends. Microsoft Excel features the Sunburst Chart, a modern radial visualization tool that displays hierarchical data as a series of concentric rings, where each ring represents a deeper categorical tier and slice angles reflect proportional values.

Structuring Your Data for a Sunburst Chart

Excel requires hierarchical data to be arranged in clean, grouped tabular columns before creating the chart:

1. Organize categorical tiers from left to right:
   • Column A: Top tier (e.g., Continent: North America, Europe).
   • Column B: Sub-category (e.g., Country: United States, Canada, Germany).
   • Column C: Product Category (e.g., Software, Hardware).
   • Column D: Numerical Metric (e.g., Revenue).
2. Ensure that parent categories are grouped consecutively without interleaving blank rows.

Inserting the Sunburst Chart in Excel

Once your table structure is populated:

• Highlight your entire data range including category headers.
• Click on the Insert tab in the Excel ribbon.
• In the Charts group, click the Hierarchy Chart icon and select Sunburst.
• Excel instantly generates the chart: the center circle displays the highest-level categories, while outer concentric rings branch outward into granular sub-segments.

Formatting and Customising Slice Visibility

Enhance readability and presentation aesthetics using built-in formatting tools:

• Data Labels: Right-click the chart and select Format Data Labels. Check both Category Name and Value to display clear financial metrics inside wider ring segments.
• Colour Palettes: Use the Chart Design > Change Colors menu to apply monochromatic or contrasting palettes that visually separate distinct parent branches.
• Title and Sizing: Resize the chart canvas to give outer rings ample space to render concise typography.

Creating sunburst charts in Microsoft Excel transforms dense multi-level tables into compelling, executive-ready presentations that make complex hierarchical relationships immediately obvious.