Create a Treemap Chart in Excel Office 365 – Simple Ways!!

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.

Select the data

• 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.

Insert Tab

• At last, you will get the chart as shown in the below image.

Treemap Chart

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!