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.