How to Create a Treemap Chart in Excel

Advertise With Us

How to Create a Treemap Chart in Excel

A treemap chart is a graphical representation of data that allows you to see the relative proportions of different items in a dataset. The items are arranged in a tree-like structure, and the size of each item is proportional to its value. Treemap charts are used to display hierarchical data, such as the size of companies by revenue, or the distribution of files on a disk.

A treemap chart is a great way to visualize hierarchical data, and Excel makes it easy to create one. Keep reading to learn how to create a treemap chart in Excel.

Understand the Components of a Treemap First.

Treemap charts are created by dividing the area of the chart into a series of rectangular tiles and then assigning a color or shade to each tile based on the value of the data it represents. The size of each tile is also proportional to the value of the data. For example, the largest tile in a treemap chart might represent the total revenue for a company, and the smallest tile might represent the revenue for a single employee.

Treemap charts are particularly useful for displaying data that has a large number of items. The tree-like structure makes it easy to see the relative proportions of the different items, and the rectangular tiles make it easy to compare the values of different items.

Create Your Treemap in Excel.


There are a few steps involved with creating a treemap chart in Excel. The first step is to create your data table. The table should have two columns: “category” and “value”. The category column should list the different categories for your data, and the value column should list the corresponding values for each category.

Next, you’ll need to create a chart based on your data table. Select the data in the table, then go to the Insert tab and select the Column chart icon.

Once your chart is created, you’ll need to format it to look like a treemap. To do this, select the chart, then go to the Format tab and select the Shape Styles icon. Under the Shape Styles pane, select the “No Outline” and “Solid Fill” options.

Next, select the “Size & Properties” pane and set the Width and Height to “Automatic”. This will ensure that your chart expands to fit the data.

Finally, you’ll need to create the legend for your chart. To do this, select the chart, then go to the Insert tab and select the Legend icon.

That’s it! You’ve now created a treemap in Excel.

What are the Benefits of Using a Treemap?


Treemaps are an excellent way to visualize data because they display data in a way that is both easily understood and highly efficient. In a treemap, each data point is represented as a block, and the blocks are then arranged in a hierarchical structure. This makes it easy to see how different data points are related to one another.

Treemaps are also very efficient because they use very little space on the screen. This makes them perfect for displaying large data sets. Additionally, treemaps are easy to update because you simply need to change the data in the underlying spreadsheet and the treemap will automatically update.

Finally, treemaps are very user-friendly. They are easy to understand and use, even for people who are not familiar with data visualization. This makes them perfect for presentations and for helping people understand complex data sets.

Use a Treemap to Visualize Data.

Overall, treemap charts are an efficient tool for data visualization. They can help you see the “big picture” of your data, and make it easier to identify patterns and trends.

Advertise with Us