Create a Treemap chart in Excel 2016

Channel:

SL Data Hub

Subscribers:

512

Published on August 2, 2021 6:28:23 PM ● Video Link: https://www.youtube.com/watch?v=Mhlg0A0DoYc

Duration: 4:49

22 views

2

Create a Treemap chart in Excel 2016

A treemap chart provides a hierarchical view of your data and makes it easy to spot patterns, such as which items are a store's best sellers. The tree branches are represented by rectangles and each sub-branch is shown as a smaller rectangle. The treemap chart displays categories by color and proximity and can easily show lots of data which would be difficult with other chart types.

Treemap charts are good for comparing proportions within the hierarchy, however, treemap charts aren't great at showing hierarchical levels between the largest categories and each data point. A sunburst chart is a much better visual chart for showing that.