Tree maps are a powerful visualization tool that helps to understand and analyze large amounts of data by displaying it in a hierarchical, tree-like structure. Excel, with its robust data analysis and visualization capabilities, allows you to create tree map charts with ease. In this guide, we'll walk you through the step-by-step process of creating a tree map chart in Excel.
Before we dive into the process, ensure you have the latest version of Excel, as tree map charts are not available in older versions. Also, familiarize yourself with the data you'll be using, as tree maps work best with hierarchical data.
Preparing Your Data
Tree maps require your data to be organized in a specific way. It should be hierarchical, with a clear parent-child relationship. For instance, you might have a dataset with countries as the top-level hierarchy, states as the next level, and cities as the lowest level.
Here's how your data should look:
| Country | State | City |
|---|---|---|
| USA | California | Los Angeles |
| USA | California | San Francisco |
| USA | New York | New York City |
Creating a PivotTable
A PivotTable can help you summarize and analyze your data. It's not a requirement for creating a tree map, but it can make the process smoother. To create a PivotTable, select your data, go to the 'Insert' tab, and click on 'PivotTable'. Choose where you want to place it and click 'OK'.
Now, drag and drop your fields into the 'Rows' section of the PivotTable. For our example, drag 'Country', 'State', and 'City' into the 'Rows' section.
Creating a Tree Map Chart
Now that your data is ready, let's create the tree map chart. Select your PivotTable, go to the 'Insert' tab, and click on 'Tree Map'. A tree map chart will be inserted into your worksheet.
By default, Excel will use the first two fields in your PivotTable as the hierarchy for your tree map. In our case, it will use 'Country' and 'State'. If you want to change the hierarchy, right-click on the chart and select 'Select Data'. In the 'Select Data Source' dialog box, you can change the hierarchy by clicking on the 'Switch Row/Column' button.
Customizing Your Tree Map Chart
Once you've created your tree map, you can customize it to better suit your needs. Right-click on the chart and select 'Format'. Here, you can change the colors, add data labels, or adjust the layout.
![Ultimate KPI Tree Guide: What Is a KPI Tree & How to Build KPI Trees That Work [2026]](https://i.pinimg.com/originals/3b/c9/99/3bc999c8440dd145b1d2b5c083d16093.png)
Changing Colors
To change the colors of your tree map, go to the 'Fill' section in the 'Format' pane. Here, you can choose a solid color, gradient, or picture for your tree map. You can also set different colors for different levels of your hierarchy.
To do this, select the level you want to change (e.g., 'State'), right-click and select 'Format'. Then, go to the 'Fill' section and change the color.
Adding Data Labels
Data labels can help you understand the values in your tree map. To add data labels, right-click on the chart and select 'Add Data Labels'. You can also format the data labels by right-clicking on them and selecting 'Format'. Here, you can change the font, color, and size of the labels.
Tree maps are a great way to visualize and understand hierarchical data. With Excel's powerful data analysis and visualization tools, creating a tree map chart is a straightforward process. So, go ahead, give it a try, and unlock a new way of understanding your data.