Get better at working with Google Sheets! Join 50,000 readers to get an actionable tip in your inbox every Monday.
Sheets tip 251: Use heatmaps to show trends in your data
Hi Reader,
Welcome to the Google Sheets Tips newsletter #251, your Monday morning espresso, in spreadsheet form!
_______
➜ Google Sheets Tip #251: Create heatmaps from your data with conditional formatting
Heatmaps are a great way to add context to your data.
Consider this dataset of monthly average temperatures in the ten largest cities in the U.S.:
It's not easy to see, at a glance, what the trends are between the different cities. It takes effort on our part to read and compare each number, and there's a risk that we miss something.
Compare this to the same table with a heatmap added:
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 and go to:
Format > Conditional Formatting
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 temperature trends across the cities, and identify the colder/warmer cities.
Learn more about heatmaps in this tutorial.
_______
If you enjoyed this newsletter, please forward it to a friend who might enjoy it.
Have a great week!
Cheers,
Ben
Google Sheets Tips
Get better at working with Google Sheets! Join 50,000 readers to get an actionable tip in your inbox every Monday.
Hi Reader, Welcome to the Google Sheets Tips newsletter #382, your Monday morning espresso, in spreadsheet form! If you feel like the AI wave is moving faster than you can keep up with, you aren't alone. The gap between "playing with a chatbot" and "building reliable AI systems" feels wider than ever, and that feeling is only increasing with every new AI announcement. For the past couple of months, I’ve been working on a new course to help address this challenge. Next Monday, I’m opening...
Hi Reader, Welcome to the Google Sheets Tips newsletter #381, your Monday morning espresso, in spreadsheet form! Since last week, the weather in the Mid-Atlantic region has been even more volatile than that mission critical spreadsheet your non-technical boss "fixed" recently. We had a day over 80F, followed by a wild 50F drop to temps in the 30's and snow squalls. And later today, we're forecast to have a severe thunderstorm and possible tornadoes. It's threatening enough that schools in...
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #380, your Monday morning espresso, in spreadsheet form! I read something online last week (source) that really resonated with me: Joy is a competitive superpower The author gave the example of the US figure skater Alysa Liu, who rocked a huge smile on her way to a gold medal at the recent Winter Olympics. As someone who has a tendency to take things too seriously, this was a good reminder for me to smile more and...