How to Create and Customise Sunburst Charts in Microsoft PowerPoint

When presenting corporate reorganisations, divisional expenditure breakdowns, or multi-tiered product categorisations, conventional pie and donut charts quickly fail due to clutter and an inability to display relational parent-child structures. Microsoft PowerPoint includes native support for sunburst charts, offering a concentric circular visualisation designed specifically for hierarchical datasets. By learning how to structure tabular data correctly and format radial slices, presenters can deliver intuitive, publication-grade data breakdowns directly on their presentation slides.

How Sunburst Charts Visualise Hierarchical Relationships

A sunburst chart represents data hierarchies through nested concentric rings, radiating outwards from the core to granular leaf nodes:

  • Inner circle: Represents the highest level of the hierarchy (such as business departments, continents, or overarching product lines).
  • Outer concentric rings: Divide each parent segment into proportional child sub-categories (such as regional offices, product sub-types, or individual budget allocations).
  • Slice angular width: Directly corresponds to the proportional numerical metric (such as quarterly revenue, headcount, or operational cost) assigned to each respective branch.

Unlike treemaps, which represent nested hierarchies within rectangular tiles, sunburst charts emphasise radial proportions, making it easier for audience members to trace departmental lineage across complex organisational trees.

Structuring Tabular Data in the Embedded Excel Grid

Generating an accurate sunburst chart depends entirely on structuring the linked spreadsheet worksheet so that PowerPoint can parse branch levels sequentially.

Organise your data into adjacent hierarchy columns followed by a final numerical metric column:

  • Column A (Tier 1 / Parent): Enter the top-level parent category name once, leaving subsequent row cells blank until the next parent group begins.
  • Column B (Tier 2 / Sub-category): Enter secondary division names aligned with their corresponding parent rows.
  • Column C (Tier 3 / Granular Branch): Enter the specific items or regional units (optional, if using a three-tier hierarchy).
  • Column D (Metric / Value): Enter numerical figures strictly on the leaf rows (the final hierarchical level). Do not sum parent totals manually, as the charting engine calculates aggregate parent ring widths automatically.

For example, if the Technology parent has two branches—Hardware (£40,000) and Software (£60,000)—enter values only on the Hardware and Software rows. The chart engine will calculate the Technology inner ring slice as £100,000 automatically.

Inserting the Sunburst Chart onto a Slide

To place the chart onto your PowerPoint presentation:

  1. Navigate to the target slide in PowerPoint.
  2. Click the Insert tab on the ribbon and select Chart from the Illustrations group.
  3. In the Insert Chart dialogue window, select Hierarchy from the left-hand category list.
  4. Choose Sunburst from the available hierarchy options and click OK.
  5. An embedded Microsoft Excel worksheet window titled Chart in Microsoft PowerPoint will pop up alongside your slide.
  6. Replace the default sample placeholder data with your structured hierarchical columns, then close the Excel window. The PowerPoint slide will update instantly.

Customising Slice Colours, Data Labels, and Layouts

Once your hierarchical data is mapped to the radial chart canvas, customise its visual design to maximise legibility during live slide presentations:

  1. Click the chart object to activate the contextual Chart Design and Format tabs on the PowerPoint ribbon.
  2. Click Change Colors on the Chart Design tab to select harmonious monochromatic or divergent palettes that match your corporate brand guidelines.
  3. To isolate and highlight a specific business division:
    • Click once on the chart to select the entire series, then pause and click a second time directly on an individual radial slice.
    • Right-click the selected slice, choose Format Data Point, and adjust its Solid Fill colour to an accent hue (such as vivid orange or deep royal blue) while leaving non-target segments muted.
  4. Click Add Chart Element > Data Labels to configure slice annotations. In the Format Data Labels pane, choose whether to display category names, numerical values, or percentages.
  5. Set label positioning to ensure text strings remain legible without overlapping narrow outer ring slices.

Best Practices for Clear Presentation Delivery

Sunburst charts are visually rich and can overwhelm viewers if packed with excessive hierarchy depth. Maintain clarity by observing these presentation guidelines:

  • Limit hierarchy depth: Restrict your dataset to two or three concentric rings. Slices on fourth or fifth-tier rings frequently become too thin to display legible text labels.
  • Group minor values: If multiple minor subdivisions each contribute less than 2% to the total metric, consolidate them into an “Other” child category in your spreadsheet to prevent micro-slice clutter.
  • Provide context: Pair your sunburst chart with a clear slide subtitle or callout text box drawing attention to key takeaways, such as the single largest parent division or the fastest-growing child sub-segment.

Get the best tech tips delivered straight to your inbox.

Join thousands of readers mastering Apple, Google, Microsoft, and Linux.