Reading Time: minutes remaining

How to Create a Sunburst Chart in Excel to Segment Hierarchical Data

Jason Morrell

by Jason Morrell 
January 24, 2022

Excel offers 2 types of hierarchy chart, the Treemap and the Sunburst chart. The big advantage of Sunbursts over Treemaps is that they can work with any number of hierarchy levels.

This post demonstrates how to set up a good Sunburst chart.

First, here is an example of what a Sunburst chart looks like:

What a finished Sunburst Chart looks like

A Sunburst chart is made up of concentric circles, and each circle is segmented.

   -   The inner circle contains the top-level category, the meal type (breakfast or lunch).

   -   The next outer circle, breaks each meal type into food or beverage.

   -   The next outer circle breaks each food or beverage into hot or cold.

   -   The outer circle contains data at the bottom of the hierarchy,
       each food or drink item.

1. How to set up the data for a Sunburst chart

Consider this hotel restaurant data where every food or beverage is categorised. THis data has 4 hierarchy levels.

Create 4 columns of data, one for each hierarchical level. Ensure that there are no empty cells in your data range.  

Sunburst Chart

2. How to create a Sunburst chart

1.  Select a single cell in your data to allow Excel to select the entire range or select the headings and the specific data range you wish to use.

2.  Click the Insert tab.

3.  Select the Insert Hierarchy Chart icon in the Charts group and select Sunburst.

Sunburst Chart
  • Each circle represents one column in the source data, with the inner circle showing the top-level data in the first column and the outer circle showing the lowest level label from the penultimate column
  • Each segment is sized proportionately, based on the volume in the last column of the source data.
Sunburst Chart

3. How to restyle a Sunburst chart

It is always worth checking out the Chart Styles and Quick Layouts on the Chart Design ribbon for different pre-configured styles (which you can modify further is desired).

Sunburst Chart
Sunburst Chart

4. How to add data values as labels to the outer ring

1.  On the Chart Design ribbon click Add Chart Element. 

2.  Hover over Data Labels and click the little options-arrow then choose More Data Label Options.

2.  Tick the Value box.

5. What next?

I hope you found plenty of value in this post. I'd love to hear your biggest takeaway in the comments below together with any questions you may have.

Have a fantastic day.

Jason Morrell blog signature
About Jason Morrell

About the author

Jason Morrell


Jason Morrell is a professional trainer, consultant and course creator who lives on the glorious Gold Coast in Queensland, Australia.


He helps people of all levels unleash and leverage the power contained within Microsoft Office by delivering training, troubleshooting services and taking on client projects. He loves to simplify tricky concepts and provide helpful, proven, actionable advice that can be implemented for quick results.


Purely for amusement he sometimes talks about himself in the third person.

SHARE

more from

Office Mastery logo
Read More
How to Consolidate Data in Excel: 2 Easy Ways to use Excel’s Consolidation Tool
Read More
Excel Screen: A Beginners Tour

JOIN THE DISCUSSION

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}
>