Blog Archive

Excel Tip: Creating Heat Maps for Management Reports

Creating Heat Maps

A heat map is nothing but a visual representation of data where color changes based on the value. For example, you can create a heat map where a cell with highest value is colored green and there is a shift towards red color as the value decreases. 
Something as shown below 
100-200
To create this, go to Home –> Conditional Formatting –> Color Scales, and choose one of the color schemes
Color Heat map
Note: Similarly, you can also insert data bars or Icon sets
source; ExcelTrump