Treemap Diagramm Excel. Create a treemap chart. The color and size of rectangles are typically correlated with the tree structure which in return makes it easier to see the groups and sizes.
Choose layout 4 first one in second row for a clean layout. The perfect tool for displaying hierarchical data. On a treemap each item is represented by a rectangular shape where smaller rectangles represent the sub groups.
If you don t see these tabs click anywhere in the treemap chart to activate those tabs.
This is also marked with legends. Click on the tree map chart type. This is also marked with legends. 1 select the data table.