Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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

  2. Go to the Insert tab > Insert Hierarchy Chart > Treemap.

    You can also use Recommended Charts to create a treemap chart by going to Insert > Recommended Charts > All Charts.

Tip: Use the Chart 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 activate those tabs.

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

Create a treemap chart

  1. Select your data.

    Data used to create the example treemap chart

  2. On the ribbon, click the Insert tab, then click Hierarchy chart icon (Hierarchy icon), and then select Treemap.

    Treemap chart on the ribbon

    Note: Use the Chart 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 activate those tabs.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.

See Also

Create a waterfall chart

Create a Pareto chart

Create a histogram

Create a box and whisker chart

Create a sunburst chart in Office

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×