Create a treemap chart in Office

Excel for Microsoft 365Word for Microsoft 365Outlook for Microsoft 365PowerPoint for Microsoft 365Excel for Microsoft 365 for MacWord for Microsoft 365 for MacOutlook for Microsoft 365 for MacPowerPoint for Microsoft 365 for MacExcel 2019Word 2019Outlook 2019PowerPoint 2019Excel 2016Excel 2019 for MacPowerPoint 2019 for MacWord 2019 for MacWord 2016Outlook 2016PowerPoint 2016Excel 2016 for MacPowerPoint 2016 for MacWord 2016 for MacExcel for iPadExcel for iPhoneOutlook 2019 for MacMore...Less

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.