Modified 24 August 2020 by Eugen Plesa

Heatmaps are a great way to add context to your data.

Suppose we have this small dataset of bounce rates:

It's not easy to see, at a glance, which days did well and which did poorly. It takes effort on our part to read and compare each number, and there's a risk that we miss something.

Heatmaps will bring attention to the high and low values in your data, those outliers that demand more attention in your analysis, and they're very easy to create.


Simply highlight the range of data you're using, open
Conditional Formatting (under Format menu) and select the Color scale option. Then choose one of the prebuilt color scales or create your own:

You can immediately see the difference.

It's now very easy to identify the days our website underperformed (in red, high bounce rate) and which days it did well (in green, lower bounce rate).

Guest Tip by Ben Collins