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.
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #377, your Monday morning espresso, in spreadsheet form! Coming to your inbox on a Tuesday this week, because it was a public holiday here in the US yesterday. Today I'm pondering whether it makes sense to write your own formulas anymore. AI tools are getting so good at writing formula syntax (and Apps Script code) that it doesn't make sense (economically at least) to spend hours crafting complex formulas yourself, if...
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #376, your Monday morning espresso, in spreadsheet form! I've been using Gemini and Gemini Canvas a lot recently for various projects. It's mind-blowing how quick it is at generating formulas and scripts that work. We're definitely at the threshold (or maybe already past it 🤔) where it doesn't make sense to write your own complex formulas or code from scratch (for specific problems with limited scope). Having said...
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #375, your Monday morning espresso, in spreadsheet form! We're still in an ice box on the east coast of the US with the snow set to hang around for a while yet. It's beautiful but I am looking forward to the ice melting so it's easier to get around. The Potomac river is covered with ice Today's newsletter is not directly related to Google Sheets. Instead, I'm sharing the sources I use to stay informed of AI...