A Heatmap color-codes values within a matrix, showing differences through variations in coloring. They are useful for visualizing differences, similarities, and trends across multiple variables.
This article describes how to go from a table or crosstab of data, such as this:
To a heatmap, like this:
Further settings are discussed below that may make finding patterns in your data easier.
Requirements
You will need a table of data that consists of two or more rows and one or more columns.
Method 1 - Simple Heatmap
1. Go to Visualization > Heatmap > Heatmap.
2. Under Inputs > DATA SOURCE > Output in 'Pages' select the table that contains the data.
Method 2 - Sorted Heatmap
Follow the same process as in Method 1, above, but add the step:
3. Under Chart > APPEARANCE > Row sorting or dendrogram and/or under Chart > Appearance > Column sorting or dendrogram select how you would like to sort the data in the table by selecting Sort by averages (ascending) or Sort by averages (descending).
This example has been sorted using Chart > Appearance > Column sorting or dendrogram > Sort by averages (ascending).
Method 3 - Heatmap with Dendrogram
Follow the same process as in Method 1, above, but add the step:
3. Under Chart > APPEARANCE > Row sorting or dendrogram and/or under Chart > Appearance > Column sorting or dendrogram select how you would like to sort the data in the table by selecting Dendrogram.
The example here has been created by selecting Dendrogram for both rows and columns. It groups together the attributes on the rows and columns by similarity.
See Also
How to Create a Heatmap using R and HTML
How to Create a Table with Conditional Formatting using R and HTML