Description:

Tree-map add-in visualizes 2 data series into sets of colored hierarchical rectangles. The color and size can represent different data series. Data analyst can use this add-in visualize the data in different categories. Financial professional can use this add-in to analysis the security market and build heat-map based on sector, industry performance, etc.

4 data columns:

The first column has the data items.

The second column has the parent level text.

The 3rd column has the number to map to the sizes of the rectangle.

The 4th column has number to map to the color values.

Features:

Click the area and navigate into the detail. Left mouse click, the navigation returns to parent level.

Mouse over the items, the value of the items are shown in the tool-tip.

The color of the map and the top level category text can be set in the setting screen.

Sample data can be used as the template to build the new customized map.

Easy to use and user friendly.

Change the tree map title by clicking the title area and enter the text as needed.

Instruction:

Download this add in and start Excel 2013 SP1 or later.

Click Insert Sample Data button to insert the sample data and view the tree map.

Build own hierarchical data and follow the same format as in the sample data, then paste into the sample data table.

Enter the top level text in the setting screen as needed.

Change colors in setting screen as needed.

Click in the title area in the tree map to enter preferred title.

Click area to navigate into the detail. Left mouse click to return to parent level.

Tree Data Map

by Garden City Consultants