Difference between revisions of "Treemaps"
| Line 1: | Line 1: | ||
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. | 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. | ||
| − | [[Image:TreemapSimple.png|thumb| | + | |
| + | [[Image:TreemapSimple.png|thumb|450px|center|alt=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. | 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 [[Tables|Table]], and Excel range or from a cube. | In XLCubed treemaps can be sourced from a [[Tables|Table]], and Excel range or from a cube. | ||
Revision as of 10:48, 19 July 2012
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.
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.
