Treemap in Excel: All Things to Know

In this article, we have described guidelines to create a Treemap chart and how to customize the chart. We will also discuss the pros and cons of using this chart in Excel.

Excel Treemap chart constructs a chronological order to give a better understanding of a dataset. The chart is represented by rectangles of different sizes and colors. So it becomes easy to understand the patterns and get a hierarchical perspective. Treemap charts are very helpful to visualize different data in a concise chart.

Treemap chart in Excel

Download Practice Workbook

You can download the practice file here.

Introduction to Treemap Chart

A Treemap chart represents hierarchical data as nested rectangles, with size and color indicating attributes, providing a compact view of data structure and relationships.

There are three main sections of a Treemap chart. These are:

  • Plot Area: The plot area is the region within a chart where the actual graphical representation of data occurs, including the bars, lines, or other elements. It defines the space where the data is visually displayed.
  • Chart Title: The chart title is a text label that provides a clear and concise description of the chart’s purpose or subject matter. It usually appears at the top of the chart and helps viewers understand the context or topic being depicted.
  • Legend: The legend is a visual guide accompanying the chart that explains the meaning of different colors, symbols, or patterns used in the chart. It provides a key to understanding the data representation and helps viewers interpret the chart accurately.

How to Create a Treemap Chart in Excel

  • First, select the data which you want to represent in the chart.

Selecting dataset

  • Next, click on the Insert tab from the menu bar and choose Treemap.

Inserting Treemap chart

  • Alternatively, you can also select the option Recommended Charts.

Selecting from Recommended Charts

  • Next, from All Charts, select the Treemap option.

Choosing Treemap from All charts

  • Finally, you will get a Treemap chart of the data.

Treemap chart of given dataset

Read More: How to Make a Treemap Chart in Excel

How to Modify/Customize Treemap in Excel

1. Add or Change Chart Title

  • First, double-click on the Chart Title, and you will see a typing cursor.

Editing Chart Title

  • Next, type the new title, you can also format that in bold letters.

New Chart Title

2. Customize Layout and Styles

  • You can customize your Treemap chart in different layouts and styles. Click on the chart, and it will show different styles in the ribbon under Chart Design.

Choosing style from chart design

3. Formatting Chart

  • You can format the treemap chart by using the Context Menu. Just right-click on the mouse, and you will get the Format Chart Area option.

Format Chart using context menu

  • You can also double-click on the chart to get the Format Chart Area window on the right side of your Excel.

Format Chart Area options

Read More: How to Add and Format Data Labels in Excel Treemap

4. Resize Chart

  • It is very easy to resize the chart. Just take the cursor to a corner or edge of the chart, you will see an arrow cursor. Move the cursor to resize the chart.

Pros and Cons of Treemap Chart


  • Treemap charts efficiently utilize space by representing data hierarchies in a compact and organized manner.
  • Treemap can effectively display hierarchical relationships within the data.
  • Treemap can reveal visual patterns and trends in the data.


  • There is a practical limit to the number of data elements that can be displayed effectively.
  • While Treemap charts provide a relative size comparison of data elements, they may not accurately represent precise values.
  • If the Treemap chart contains too much data or multiple levels of hierarchy, it can overwhelm users with excessive information.

Things to Remember

  • Ensure your data has a logical hierarchical structure, with values that can be accurately represented by the size of the rectangles.
  • Excessive levels of hierarchy can clutter the Treemap and make it challenging to interpret. Focus on the most important levels to maintain clarity.
  • Use consistent color schemes and size scaling across the Treemap to ensure accurate comparisons between categories.


In this article, we have the details about Treemap Chart in Excel. We sincerely hope you enjoyed and learned a lot from this article. Additionally, if you want to read more articles on Excel, you may visit our website, Exceldemy. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.

Frequently Asked Questions

1. Can I export a Treemap chart from Excel to other applications or formats?

Yes, you can export Treemap charts from Excel to other applications or formats. Excel provides various export options, such as saving the chart as an image file (e.g., JPEG, PNG), copying and pasting the chart into other programs, or embedding the chart in documents (e.g., Word, PowerPoint). Additionally, you can save the entire Excel file containing the Treemap chart and share it with others who have Excel installed.

2. Can I create a dynamic or interactive Treemap chart in Excel?

While Excel’s native Treemap chart does not offer dynamic or interactive features, you can create a dynamic effect by using features like data validation, cell references, or macros. These techniques allow you to change the chart’s underlying data dynamically, enabling interactive behavior based on user inputs or changes to

Treemap Chart Excel: Knowledge Hub

<< Go Back to Excel Charts | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!


Maruf Hasan
Maruf Hasan

Maruf Hasan, a BSc Electrical & Electronic Engineering graduate from Ahsanullah University of Science & Technology, boasts over a year of service as an Excel & VBA Content Developer at Exceldemy. He authored 30+ insightful articles and offers solutions to diverse Excel challenges. Maruf's exceptional content reflects his passion for Microsoft Office, problem-solving, and writing. Committed to simplifying complex processes, he significantly contributes to Exceldemy and is deeply enthusiastic about continuous learning in Microsoft Office Suite and data... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF