This article describes how to go from a table or crosstab of data, such as this:
To a heat map plot, 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
- Select your table
- Select Automate > Data Bars > Shading.
- Select from the available gradients
- OPTIONAL Select More Rules if you want to format the cells vased on their values, or to include NETs/SUMs.
The results are as follows: