Create a treemap chart in Office 2016

A treemap chart provides a hierarchical view of your data and makes it easy to spot patterns, such as which items are a store's best sellers. The tree branches are represented by rectangles and each sub-branch is shown as a smaller rectangle. The treemap chart displays categories by color and proximity and can easily show lots of data which would be difficult with other chart types.

Treemap charts are good for comparing proportions within the hierarchy, however, treemap charts aren't great at showing hierarchical levels between the largest categories and each data point. A sunburst chart is a much better visual chart for showing that.

Example of a Treemap Chart in Office 2016 for Windows

Create a treemap chart

  1. Select your data.

    Data used to create the example treemap chart
    Data used to create the example chart above
  2. Click Insert > Insert Hierarchy Chart > Treemap.

    Treemap chart on option on the Insert tab in Office 2016 for Windows

    You can also use Recommended Charts to create a treemap chart, although the treemap chart will only be recommended when empty (blank) cells exist within the hierarchal structure (click Insert > Recommended Charts > All Charts tab).

Tip: Use the Design and Format tabs to customize the look of your chart. If you don't see these tabs, click anywhere in the treemap chart to add the Chart Tools to the ribbon.

Design and Format tabs for the Chart Tools

Change label display

Excel automatically uses a different color for each of the top level or parent categories. However, you can also use the layout of the data labels to distinguish between the categories.

Picture of the Treemap top level category displayed in a banner

  1. Right-click one of the rectangles on the chart > Format Data Series.

  2. Under Series Options > Label Options, pick the display option you want.

    Format Data Label task pane showing the options for a Treemap chart

Tip: To read more about the treemap chart and how it helps you visualize hierarchical data, see this blog post on the treemap and sunburst chart by the Excel team. You may also be interested learning more about the other new chart types described in this blog post.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!