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.
Excel 2016’s new Treemap chart offers an interesting way to visualize a hierarchy of data. With it, you can compare data for different categories at a glance, such as revenue for a bookstore by book genre and sub-genres or laptop sales by manufacturer and model. Here’s how to create a Treemap in just a couple of clicks
How to make Treemap graph in Excel 2016
Open your spreadsheet, select the target data, and click Insert – Insert Hierarchy Chart -Treemap. The chart drops in and opens the Chart Tools/Design Ribbon menus. Scroll across the Design options and select one that fits your project.