Follow the steps below to easily create a heat map in Google Sheets.
First, open a new Google Sheets document. Enter your data in a table format. For example, you could have a list of products in column A and their corresponding sales numbers in column B.
Click and drag to highlight the cells containing your data. In our example, it would be the sales numbers (Column B, excluding the header).
Go to the menu and click on Format. Select Conditional formatting from the dropdown menu.
A panel will open on the right side of your screen. Select “Color scale”. Below that, you'll see three color buckets.
Here's how to set it up:
Minpoint: Choose "Percent" and enter 0%, then select a light color. In our example, we choose red.
Midpoint: Choose "Percent" and enter 50%, then select a middle color.
Maxpoint: Choose "Percent" and enter 100%, then select a dark color.
You can also select from any of the default color scales to represent your heat map.
Click “Done” after setting up your color scale. Your data should now be displayed as a heat map, with colors representing different data values.
We hope that this article has helped you and given you a better understanding of how to make a heat map in Google Sheets. If you enjoyed this article, you might also like our articles on how to change the default font in Google Sheets and how to fix circular dependency detected in Google Sheets.
