A Treemap chart is one of the built-in chart types in MS Excel. It will provide a hierarchical view of data. In this treemap chart, each branch is represented by rectangles, and the sub-branch is represented as a small rectangle. In this article, we will see how to create a Treemap Chart in Excel Office 365.
To know more different types of Excel Charts, refer to this link.
Steps to Insert a Treemap Chart:
- First, you need to select the input range that you want to create a chart.
- Then, on the Insert Tab, select the Insert Hierarchy Chart icon.
- After that, you need to select the Treemap Chart from the drop-down menu.
- At last, you will get the chart as shown in the below image.
Pros and Cons:
Pros:
- Quick visualization of hierarchical data.
- Easy to create.
Cons:
- Every data must be stored as a category.
- It has limited options when compared to other chart types.
A Short Synopsis:
In this article, you can easily understand the steps to create a Treemap Chart in Excel Office 365. Drop your feedback in the comment section. Thanks for visiting Geek Excel. Keep Learning!
Top comments (0)