The Treemap chart is a built-in chart type in Excel 2016+. A treemap chart displays hierarchical data in rectangles proportionally sized according to the amount of data in each category. Treemap charts are lacking many of the controls available in other chart types, but they are an interesting way to quickly visualize certain kinds of data.
Pros
- Quick visualization of hierarchical data
- At-a-glance breakdown data in categories
Cons
- Data must be sorted by category
- Missing many of the options available in other chart types
The sunburst chart is a built-in chart type in Excel 2016+. A sunburst chart is used to display hierarchical data in a circular format where each level of the hierarchy is represented as a ring. Top level categories make up the inner ring, and sub-categories are plotted as outer rings. Segments in each ring are sized proportionally using a value series. Like a treemap chart, the sunburst chart can be used to compare relative sizes.
Pros
- Quick visualization of hierarchical data
- At-a-glance breakdown of data in categories
Cons
- Data must be sorted by category
- Limited options for controlling format and presentation
