If you have data that you want to visualize graphically, but a chart just won’t do it, try a heat map. You can create a heat map in Excel to present your data in an easy-to-read way.
Create a heat map in Excel
A heat map is a visual representation of data using colors. It can be a chart or map where the colors correspond to the numerical values in a data set.
The most common example of a heat map is when you are watching the weather on your favorite news channel. You can see temperatures across the country or region that are red for warm, orange for hot, and yellow for cooler temperatures, for example.
This type of visual is useful when you have a wide range of values that span multiple categories. For example, you might have sales for store departments over years or averages of student grades over weeks or months.
