Creating a heatmap Go to a map tab, or use [+] Add map to add one. If the map configuration panel isn't showing, click Tools > Change map. Click on the Heatmap item to the left of the map.
How do I create a heat map in Google Sheets?
- Select your data in the Google Spreadsheet.
- Go to Format - Conditional Formatting (or Right click). This will open a Conditional format rules panel.
- Select the colours for your Minpoint, Midpoint and Maxpoint.
- Adjust your Midpoint to a Percentile.