A treemap chart displays hierarchical data as nested rectangles. Each rectangle represents a category, and its size corresponds to a numeric value. This chart type is useful for showing proportions across multiple levels of a hierarchy, such as product sales by region and subcategory. PowerPoint does not include a native treemap chart type, but you can create one by inserting an Excel treemap chart into your slide. This article explains how to prepare your data in Excel, insert the chart into PowerPoint, and format it for a professional presentation.
Key Takeaways: Building a Treemap Chart in PowerPoint
- Insert > Chart > All Charts > Treemap: Opens the Excel data sheet where you paste your hierarchical data.
- Two-column hierarchy with a third column for values: Required data layout so the treemap correctly groups and sizes rectangles.
- Chart Design > Change Chart Type: Lets you convert an existing chart to a treemap without rebuilding from scratch.
Understanding the Treemap Chart and Its Data Requirements
A treemap chart displays data as a set of nested rectangles. The outermost rectangles represent the top level of your hierarchy. Each rectangle is subdivided into smaller rectangles that represent subcategories. The area of each rectangle is proportional to the numeric value assigned to that category. This makes treemaps effective for visualizing part-to-whole relationships across multiple levels, such as company revenue by division and product line.
To build a treemap in PowerPoint, you must first prepare your data in a specific layout. The data must include at least two columns that define the hierarchy and one column with numeric values. The hierarchy columns must be in order from the broadest category to the most specific subcategory. For example, Region, City, and Sales. PowerPoint reads these columns to create the nested rectangle structure. If your data has only one hierarchy level, the chart will still work but will display only one level of rectangles without subdivision.
The chart is built using Excel’s chart engine embedded inside PowerPoint. When you insert a treemap chart, PowerPoint opens an Excel worksheet window where you can paste or type your data. This Excel sheet is linked to the chart in the slide. Any changes you make to the data in that sheet update the chart automatically. You do not need to have Excel installed separately, but the chart will only work if your PowerPoint version supports it. Treemap charts are available in PowerPoint for Microsoft 365, PowerPoint 2019, and PowerPoint 2016.
Preparing Your Excel Data for the Treemap Chart
Before inserting the chart, organize your data in a clean table. The first column should contain the top-level categories. The second column should contain the subcategories. Additional columns can represent deeper levels of the hierarchy, but the chart will only display the first two or three levels clearly. The last column must contain numeric values. Each row represents one data point.
Example data layout:
| Region | City | Sales |
|---|---|---|
| North | Chicago | 15000 |
| North | Detroit | 12000 |
| South | Atlanta | 18000 |
| South | Miami | 14000 |
Do not include blank rows or merged cells. Every cell in the hierarchy columns must contain a value. Empty cells will cause the chart to display missing categories or incorrect grouping. If you have more than two hierarchy levels, place them in separate columns in order. The chart will automatically nest the subcategories under the parent categories.
Steps to Insert a Treemap Chart in PowerPoint
- Open your PowerPoint presentation and select the target slide
Choose the slide where you want the treemap chart to appear. Make sure the slide has enough space for the chart and any accompanying text. - Go to Insert > Chart
Click the Insert tab on the ribbon. In the Illustrations group, click Chart. The Insert Chart dialog box opens. - Select Treemap from the chart gallery
In the Insert Chart dialog, click All Charts on the left. Scroll down or find Treemap in the list of chart types. Click the treemap icon and then click OK. PowerPoint inserts a placeholder treemap chart and opens an Excel worksheet window with sample data. - Replace the sample data with your own data
In the Excel worksheet window, select the sample data cells and paste your prepared data. The first row should contain column headers. The chart on the slide updates automatically as you paste or type data. If the chart does not update, close the Excel window and reopen it by clicking Edit Data on the Chart Design tab. - Adjust the data range if needed
If your data extends beyond the initial range, drag the blue border in the Excel worksheet to include all rows and columns. The chart refreshes to reflect the new range. - Close the Excel worksheet window
Click the X button on the Excel worksheet window. The chart remains on the slide with your data. You can reopen the worksheet later by right-clicking the chart and selecting Edit Data.
Formatting the Treemap Chart for Clarity and Style
After inserting the treemap, you can customize its appearance using the Chart Design and Format tabs. The Chart Design tab offers chart styles and color palettes. The Format tab lets you adjust individual chart elements such as the plot area, data labels, and legend.
To show values inside the rectangles, add data labels. Click the chart, then click the plus sign icon next to the chart border. Check the Data Labels box. By default, labels show the category name. To display the numeric value as well, right-click any data label, choose Format Data Labels, and check Value. You can also change the label font, size, and color from the Home tab or the Format Data Labels pane.
To change the color scheme, click the chart and go to Chart Design > Change Colors. Choose a built-in color set that matches your presentation theme. For more precise control, select individual rectangles and use the Format Data Point pane to apply a specific fill color. Be careful not to override the automatic coloring that distinguishes hierarchy levels.
If your hierarchy has many levels, the treemap may become cluttered. To simplify, right-click the chart and select Format Chart Area. In the Treemap Options section, adjust the Number of Levels setting. Reducing this to 2 or 1 hides deeper subcategories and shows only the top levels. You can also enable or disable the chart legend from the plus sign icon.
Common Issues When Building a Treemap Chart in PowerPoint
Treemap chart option is missing from Insert Chart dialog
The treemap chart type is available in PowerPoint for Microsoft 365, PowerPoint 2019, and PowerPoint 2016. If you are using an older version such as PowerPoint 2013 or earlier, the treemap option does not appear. In that case, create the treemap in Excel using the same data layout, copy the chart, and paste it into PowerPoint as a linked or embedded object. To link the chart, use Paste Special and choose Paste Link > Microsoft Excel Chart Object.
Rectangles are not sized correctly or show zero values
This usually happens when the numeric column contains blank cells or text values. Ensure all cells in the value column are numbers. If a value is zero, the rectangle will still appear but with zero area. To hide zero-value categories, filter them out in the Excel worksheet before pasting the data. Also check that the hierarchy columns do not contain duplicate rows that confuse the grouping logic.
Chart does not update after editing data in the Excel worksheet
If the chart does not refresh, close the Excel worksheet window and then click the chart. On the Chart Design tab, click Edit Data and select Edit Data again. The worksheet reopens with the current data. If the problem persists, delete the chart and insert a new one. Avoid editing the data while the chart is selected in a different program window, as this can break the link.
Treemap Chart vs Other Hierarchical Chart Types in PowerPoint
| Feature | Treemap Chart | Sunburst Chart |
|---|---|---|
| Visual structure | Nested rectangles | Concentric rings |
| Best for | Comparing proportions across many categories | Showing hierarchical depth with many levels |
| Number of hierarchy levels supported | Up to 3 levels clearly visible | Up to 5 levels clearly visible |
| Data label placement | Inside rectangles only | Inside ring segments |
| Available in PowerPoint | Microsoft 365, 2019, 2016 | Microsoft 365, 2019, 2016 |
Both chart types are available from the same Insert Chart dialog. Choose a treemap when your data has two or three hierarchy levels and you want to emphasize the size difference between categories. Choose a sunburst when your data has four or more levels and you need to show the nesting structure clearly.
You can now insert a treemap chart into any PowerPoint slide using Excel data. Prepare your data in a clean two-level hierarchy with numeric values. Use the Chart Design and Format tabs to adjust colors, labels, and hierarchy depth. For deeper hierarchies, consider using a sunburst chart instead. Try adding animation to the treemap by selecting the chart and applying a Wipe or Grow animation from the Animations tab to reveal categories one by one during your presentation.