Skip to main content
Tech

Spice up your spreadsheets with geographical heat maps

Heat maps are an easy-to-use method for data visualization in Excel.
article cover

Emma Chieppor

• less than 3 min read

TOPICS: Tech / Emerging Tech / Digital Twins

Feeling dull and need to spice up your spreadsheets? Bring the heat by creating a geographical heat map to visualize data variation by region. A geographical heat map uses color shading to display how values differ based on location. Excel recognizes geographic locations including countries, states, counties, and postal codes.

Creating a geographical heat map has never been easier, thanks to Excel. Just select any cell within your table that contains data by region, and then go to Insert > Maps > Filled Map. And just like that, Excel has converted your boring data table into a colorful geographical heat map.

For even more formulas, shortcuts, and other hot spreadsheet tips, make sure to follow Excel Dictionary to become a spreadsheet expert!

About the author

Emma Chieppor

Morning Brew

Morning Brew delivers quick and insightful updates about the business world every day of the week from Wall St. to Silicon Valley.

By subscribing, you accept our Terms & Privacy Policy.