Treemaps

Revision as of 10:47, 19 July 2012 by Colin Overton (talk)

Treemaps are a new visualization available in V7.1 of XLCubed. They can show the relationship between two measures, and their variance across a dimension.

Treemap of Sales vs Profit
Treemap of Sales vs Profit

The above treemap plots Sales against Profit across the top ten states in the USA. In this example the size of the area represents the total sales, and the colour shows how profitable the sales in that area were.

In XLCubed treemaps can be sourced from a Table, and Excel range or from a cube.