Sunburst charts

A sunburst chart, available from Excel 2016 onwards, is a great way of visualising hierarchical attributes.

 

A simple example could be a company’s global sales, using a geographical hierarchy from continent, to country, to city with this dataset:

 

 

Select your data, go to the Insert menu and select Charts – See All Charts – Sunburst.

 

 

Your sunburst chart helps you to identify where the bulk of your sales are coming from and visually compare your continents, countries and cities against each other.

 

Leave a Reply

Your email address will not be published. Required fields are marked *