In Excel 2016, a couple of new charts were added. One of them was the treemap chart. We are today going to introduce you to its features and purpose, and we are going to describe everything it provides.
The treemap chart is a chart that displays hierarchical, tree-structured, data using nested rectangles.
The tree branches are represented by rectangles and they are tiled with smaller rectangles that represent sub-branches. It displays categories by color and proximity, which is great if you want to easily show a lot of data.
How to create one?
First, you will need a set of data that you want to be represented in the treemap chart.
Then you are going to follow these steps:
- Select the entire data set that you want to convert, and go to the "Insert" tab that is located on the ribbon.
- Then select "Insert Hierarchy Chart" and select the Treemap.
And that's how you add a treemap chart, but you can also do it in another way:
- Select the entire data set, and go to the "Insert" tab that is on the ribbon.
- Then select „Recommended Charts", and then go to "All Charts" where you can find the treemap.
The treemap chart is used when you have a lot of data that you want to represent but there is no available space. It can store thousands and thousands of data points, and your data can be easily organized.
For example, you can make a treemap chart that shows daily food sales, categorized by breakfast and lunch. The food with the biggest rectangle that is on the top is the one that has the most sales.
How to customize it?
If you wish to change the design or customize the chart exactly how you want, then select the chart and on the ribbon, two tabs will appear, "Design" and "Format".
You can find a couple of designs that you may like. There are a lot of other options which can certainly help you.
If you head right to the "Design" tab, you will find on the left side of the screen a section that is called "Add Chart Element".
If you click on it, you will have three options where you can choose to add a:
Chart Title - Here you can obviously set how the chart is going to be named.
Data Labels - There you can find the "More Data Label Options" option where you can set up in detail how the label is going to look.
Legend - And the legend, which just adds a legend to one side of the chart.
Pros and cons
The treemap chart is great for storing large amounts of data because it has a lot of space. It accurately shows the relationships between two elements in a hierarchical order. We mentioned an example earlier in this article.
It doesn't display data that varies in magnitude, and it also can't display a negative value. And it can be problematic if you want to print a treemap with a large amount of data.
It's a really good chart that was definitely needed. If you need to store huge amounts of data hierarchically, this is the right chart. You have everything that you will need, and it is great nonetheless.