Treemap Chart in Excel: How to Create One Step by Step

Charts & pivot tables · Updated November 20, 2026

To create a treemap chart in Excel for Microsoft 365 on Windows, arrange your data in hierarchy columns with a numeric value column, select the data, then choose Insert > Insert Hierarchy Chart > Treemap. Excel turns the values into nested rectangles, making it easier to compare parts of a whole and spot larger or smaller contributors within categories.

A treemap works best when your data has several levels, such as region, product group, and product. Each rectangle represents a data item; its area reflects the item’s value, while its position within larger rectangles shows the hierarchy. Prepare the rows carefully before inserting the chart, because a clear data structure is what makes the result readable.

What You’ll Need

  • Microsoft Excel for Microsoft 365 on Windows. The steps are similar in newer desktop editions that include Treemap charts. Excel for Mac may place chart commands differently; Excel for the web may not offer the same options in every account or build.
  • A table with one column for each category level and a final column of numeric values. For example, use Region, Department, Item, and Sales.
  • Consistent category names and numeric values. Treemaps are designed for nonnegative values; negative values do not have a meaningful rectangle area.
  • Optional: a workbook copy or a separate worksheet where you can prepare and check the chart’s source data.

Step-by-Step

  1. Arrange the source data in hierarchy order. Put the broadest category in the first column, progressively narrower categories in the columns that follow, and the value to compare in the last column. For example, use Region, Department, Product, and Sales, with one record per product. A row might identify the North region, Accessories department, and a particular product, followed by its sales amount. Use one header row and avoid blank rows inside the data. Don’t add subtotal or grand-total rows: Excel will treat them as data points, which can inflate the chart.
  2. Check names and values. Use consistent spelling for categories that should be grouped together. If you have North in some rows and N. in others, Excel may show them as separate categories. Confirm that the final column contains numbers rather than text that only looks numeric. Remove or investigate negative values, and decide whether zero-value rows are useful: they may produce no visible area or an unhelpful label. If the same full category path appears repeatedly, summarize the records first when you want one rectangle for the combined total.
  3. Add clear column headings. Include a short header above every hierarchy level and above the numeric values. Headers help Excel identify the fields and make it easier to understand the chart later. Avoid merged cells, multirow headings, and decorative title rows within the selected range. If your original report has those features, copy the clean rows and columns to a separate worksheet for charting.
  4. Select the complete data range. Click a cell in the prepared data and select the full contiguous range, including the headings. Excel often detects a connected data block automatically, but check that the selection includes every category column and the value column—and does not include unrelated notes or totals. If you turn the range into an Excel Table first, select it and press Ctrl+T on Windows, then confirm that My table has headers is selected. On Mac, use Command+T. A table can make it easier to manage a changing source list.
  5. Insert the treemap. On the ribbon, choose Insert > Insert Hierarchy Chart > Treemap. Excel adds a chart to the worksheet using the selected range. If the chart option is unavailable, check that you are using a desktop version with hierarchy charts and that Excel has a valid selection containing category columns and numeric values. On Mac, look for Treemap under the Insert tab’s chart options; the exact grouping can vary by release. In Excel for the web, use the option if it appears, or open the workbook in the desktop app for the full chart controls.
  6. Check that Excel read the hierarchy correctly. The first category column should define the broad grouping, the next columns should create nested levels, and the final numeric column should determine rectangle size. Look for categories that appear as separate groups unexpectedly, blank labels, or a single rectangle that dominates the display. These usually point to inconsistent names, an incorrect selection, or an unusually large source value. If the hierarchy is backwards, rearrange the category columns in the source and insert a fresh chart to see the revised grouping.
  7. Add a useful title and labels. Select the chart and replace the default title with a short description that identifies the measure and time period, such as Sales by Region and Product. To control labels, use Chart Design > Add Chart Element > Data Labels, then choose an available label placement. For more label settings, open the formatting options for the data labels. Treemap label choices can depend on the Excel version and chart; if labels overlap or are clipped, show fewer details or make the chart larger rather than forcing every label to display.
  8. Format the chart for comparison. With the chart selected, use Chart Design to explore chart styles and color options. Pick colors that distinguish the top-level groups without making neighboring rectangles hard to tell apart. Keep the formatting restrained: strong colors should help viewers find groups, not imply a meaning that is not in the data. Resize the chart by dragging a corner handle, and move it away from other content if labels or the chart title feel crowded.
  9. Refresh and verify the result. Compare a few visible rectangle sizes with their source values and confirm that the chart includes the intended records. If you added rows after creating the chart, check whether the chart’s source range includes them. Charts based on an Excel Table generally use its expanding range, but verify the result after adding data. For a normal cell range, select the chart and use Chart Design > Select Data to review or adjust the source range. Save the workbook after checking the final chart.

Common Mistakes

Including totals alongside detail rows: A subtotal is not just a label; Excel plots it as another value. Including both the subtotal and the items that make it up double-counts the data visually. Keep the source to one consistent level of detail, without totals mixed into the records.

Using only one category level: A treemap can still display a single category column and values, but its defining nested structure will be limited. If the goal is to compare a short list of items without meaningful subgroups, a bar chart may be easier to read.

Expecting rectangle area to show every detail: Treemaps are good for relative size and grouping, but small differences between similar values can be hard to judge by eye. Use the chart to identify broad patterns, and consult the underlying values or a table for precise comparisons.

Letting inconsistent labels split a group: Extra spaces, spelling variations, and inconsistent abbreviations can make what should be one category appear as several. Standardize labels in the source before charting, and review the result for unexpected duplicate-looking groups.

Using colors as if they encode a second measure: A treemap’s colors may distinguish categories, but a color change does not automatically mean a value is higher or lower on another scale. Explain any intended meaning in the title or nearby notes, and avoid implying one that the chart does not represent.

Tips

Choose category levels that answer a real question. For a sales overview, Region, Product Group, and Product may be useful; adding several levels of internal codes may create a cluttered chart without making the pattern clearer. If there are many tiny categories, consider combining them into a clearly named group such as Other before building the chart, while preserving the detailed records elsewhere.

Keep units and reporting periods consistent. A chart combining dollars with units sold, or mixing monthly and yearly totals, cannot be interpreted as a fair size comparison. Add the unit and time period to the chart title or a nearby note, especially when someone might view the chart outside its original worksheet.

For a chart that will be updated regularly, keep the source data in a tidy Excel Table and avoid inserting unrelated columns into the chart’s source. Add new records as rows and then check that the chart includes them. If the source range changes substantially, use Chart Design > Select Data to confirm the chart still points to the intended fields.

Make a quick readability check at the size where people will actually view the chart. A chart that looks fine when zoomed in may become difficult to scan in a report or presentation. Shorten long category names in the source only if the shortened names remain unambiguous, and keep a full-detail table available for reference.

Troubleshooting

Treemap is missing from the Insert menu: Confirm that you are using an Excel edition that supports hierarchy charts, and try the desktop app rather than a limited web interface. Check the Insert tab’s chart options for a hierarchy-chart group. If the command is still unavailable, update Excel or use a chart type supported by your version.

The chart is blank or shows unexpected results: Confirm that the selected range includes the category columns and the numeric value column, with headers at the top. Check that values are numeric and that there are no blank rows breaking up the source. If Excel selected only part of the data, select the full range and insert the chart again.

Groups or labels appear in the wrong place: Review the order of the category columns and make sure the broadest grouping is first. Look for inconsistent names and empty cells. Correct the source, then create a new chart if the existing one is difficult to repair. This is often faster than trying to format a chart built from an incorrect hierarchy.

Some rectangles are tiny or labels are missing: Check whether one or two large values are dominating the scale, and confirm the underlying numbers are valid. Small rectangles may not have room for text, so Excel can omit or crowd labels. Enlarge the chart, reduce the number of displayed labels, or filter and chart a smaller set of categories. Don’t change valid source values just to make the picture look more balanced.

New rows do not appear: If the chart uses a regular cell range, the source may not include rows added below it. Select the chart, choose Chart Design > Select Data, and adjust the range. If the data is an Excel Table, check that the new records were added to the table rather than placed outside it, then confirm that the chart updates.

Frequently Asked Questions

What data layout does an Excel treemap need?
Use one column for each level of the hierarchy, followed by a numeric value column. Each row should describe a leaf-level item and its value, with a header above every column.

Can I create a treemap with just categories and values?
Yes. One category column and one numeric column can create a treemap with a single category level. Use multiple category columns when you want nested groups, such as region, department, and item.

Can a treemap show negative numbers?
Treemaps use rectangle area to represent values, so negative numbers do not have a useful area in this chart. Investigate negative entries and choose a different visualization if displaying positive and negative amounts is important.

How do I change the colors in an Excel treemap?
Select the chart and review the color and style choices on Chart Design. Available controls vary somewhat by Excel version. Choose a palette that keeps related groups understandable and remains legible on your worksheet.

Why are some category names not displayed?
Small rectangles may not have enough space for their labels, and long names can also be clipped. Make the chart larger, simplify labels, or reduce the number of categories shown. Keep the source table nearby when readers need exact names and values.

Can I make a treemap update when I add records?
Often, yes. An Excel Table is a practical source for changing records, but check the chart after adding rows to confirm that the new data is included. For a chart based on a fixed range, expand the source through Chart Design > Select Data.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.