How to Make a Treemap in Excel
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
1. Highlight the data you want to use for your Treemap.
2. Click the Insert tab.
3. Click the Insert Hierarchy button > Treemap. Excel will create and insert a Treemap chart into your spreadsheet.
4. Double-click the chart to format it. You can apply a chart style, for example, edit the chart title, select a different color scheme, and so on.
When your data is logically categorized and ordered, you can use a Treemap to easily find patterns in that information.