What is Sunburst and Treemaps charts: How to create these 2 in excel

What is Sunburst and Treemaps charts

Sunburst and Treemaps charts are hierarchical charts which is used to show multi level variable values. We will be using this chart type to compare parts to a whole, or when several columns of categories form a hierarchy. Let us take an example of Olympics to understand this. We got data of matches participated in Olympics by different countries for different categories of games. We can see the data in the below image.

What is Sunburst and Treemaps charts
Hierarchical data

From the above data set if we want to plot bar chart, Line chart or pie chart then chart will not show complete data by any of the charts.

Treemaps chart in excel
Other charts to represent hierarchical data

To overcome this problem … Continue Reading