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:
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.
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.
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).
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.
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
