How to create Heat Maps in Google Sheets

Reading Time: 3 minutes

In this article, we’ll learn how to create heat maps in Google Sheets using conditional formatting and explore options to style the heat maps.

Visualizing Data Using Heat Maps in Google Sheets

You can visualize your data table by creating heat maps using conditional formatting, which are graphical representations of data that utilize color-coded systems.

  • In this article, we will run through how you can create heat maps in Google sheets using conditional formatting. 
  • If you follow the steps as described in this article, you will get a heat map view as shown below :
Heat map of the car sales made for individual days for multiple weeks
Figure 1: Heat map of the car sales made for individual days for multiple weeks

Create Heat Maps in Google Sheets in 3 Steps

Step 1: Select and prepare data

  • The first step is to select the dataset of interest to create the heat map of.
  • Keep in mind that you do not have to select the column and row headers, just select the data of interest.
  • Select cell B3 and drag the selection down to F9.
Selection of cells to create the heat map
Figure 2: Selection of cells to create the heat map

Step 2: Insert Conditional Formatting

  • After selecting the cells, click on the Format button on the navigation bar.
  • Select Conditional Formatting.
Applying conditional formatting on the dataset
Figure 3: Applying conditional formatting on the dataset

Step 3: Create a multicoloured heat map

  • Click on the Color scale tab.
  • Select Default to choose the colour styling you want for your heat map
  • On the left, you can see a bi-coloured heat map based on the min-max value of the dataset.
Styling the heat map using Color Scale
Figure 4: Styling the heat map using Color Scale
Select the colour scale you like
Figure 5: Select the colour scale you like

Styling the Heat Maps in Google Sheets using Minpoint-Maxpoint

  • Select the Minpoint drop-down menu and explore options.
  • We are using Min Number as the criteria. You can visualize the heatmap by choosing various options such as Number, and Percentile.
  • You can select the colour you want to assign to minimum values.
Various options of the Minpoint drop-down menu
Figure 6: Various options of the Minpoint drop-down menu
Selecting the colour for minimum values
Figure 7: Selecting the colour for minimum values

Using other parameters to style the heat map

  • Just like how you styled the heat map using Minpoint, you can do the same using Midpoint and Maxpoint drop-down menus.
Using midpoint drop-down menu to explore styling options
Figure 8: Using midpoint drop-down menu to explore styling options
Using light blue colour for mid values. On the left, you can see the modified heat map
Figure 9: Using light blue colour for mid values. On the left, you can see the modified heat map

See Also

Here are some related articles that you may find useful:

https://blog.tryamigo.com/gantt-charts-in-google-sheets/

https://blog.tryamigo.com/create-an-organizational-chart-in-google-sheets/

https://blog.tryamigo.com/tree-map-charts-in-google-sheets/