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.
