- Step 1: Enter data. Enter the necessary data in a new sheet. ...
- Step 2: Select the data. Select the dataset for which you want to generate a heatmap. ...
- Step 3: Use conditional formatting. ...
- Step 4: Select the color scale.
How do I make a map in Google Sheets?
Than go to Insert and select Chart: In Chart Editor go to Chart types and scroll down to Map and select choropleth or bubble map. Move to customisation menu in order to edit the map. You can select only free colours that will represent the minimal value, median value and maximum value.Jan 14, 2017