Working with Tree Map

A tree map is a way of visualizing hierarchical data as a set of interrelated bubbles. Each hierarchy branch is represented by a rectangle that consists of smaller rectangles, which are subbranches. The area of each rectangle is proportional to value of the corresponding hierarchy element. Rectangle color also depends on the value of the hierarchy element.

A tree map can be used to show sets of two values for hierarchical data:

Tree map advantages:

To get started with a bubble chart:

  1. Get data.

  2. Click the Tree Map button in the Insert group of the Foresight ribbon tab.

A tree map is created on a new sheet in a Microsoft Excel workbook. A tree map sheet is inserted after the active sheet in a Microsoft Excel workbook.

NOTE. One table can be used as a data source only for one tree map.

Example of tree map:

Use the Format group of tabs on the side panel to determine tree map settings:

NOTE. The setup is similar to setup of fill of the Map data view.

See also:

Data Express Analysis Mode