Working with Tree Map

A tree map is a way of visualizing hierarchical data as a set of interrelated bubbles. Each hierarchical 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 hierarchical element. Rectangle color also depends on the value of the hierarchical element.

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

Tree map advantages:

To start working 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 separated 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