Heat Map


To create a heat map in Excel, simply use conditional formatting. A heat map is a graphical representation of data where individual values are represented as colors.

To create a heat map, execute the following steps.

1. Select the range B3:M11.

Heat Map Data

2. On the Home tab, in the Styles group, click Conditional Formatting.

Click Conditional Formatting

3. Click Color Scales and click a subtype.

Click Color Scales

Result. A heat map with numbers.

Heat Map with Numbers

4. Select the range B3:M11.

5. Right click, and then click Format Cells (or press CTRL + 1).

6. Select the Custom category.

7. Type the following number format code: ;;;

Custom Number Format

8. Click OK.

Result. A heat map in Excel.

Heat Map in Excel

Note: you can clearly see that the summer of 2014 in New York was cool and that Christmas 2015 in New York was warm.

Previous articleHow to use GETPIVOTDATA in Excel
Next articleHow to Lock Cells in Excel