Create a Geographic Heat Map in Excel with a Free Add-In

In this video, we create a geographic heat map in Excel using a free Add-in.

We have a spreadsheet containing the number of subscribers from different countries in the world.

By using the Geographic Heat Map Add-in, we plot a red to green colour scheme across the image of a world map.

This data visualisation will look great on your Excel reports and dashboards. We can see a pattern in our subscribers and the parts of the world where we are successful.

In the video, we also edit the data to show the geographic heat map automatically update with the changes.

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[rodneymullins]

Extremely Helpful!!! Was able to get what I needed. Thank You!!!

[hannafincontractorstv]

Very simple guidance for something that I thought was complicated! Thanks! (I used the 2016 version of excel but the advice still worked fine !)

[theofficelab]

Fortunately, with the recent versions of Excel and PowerPoint such a Map Chart function is already build in without requiring any additional installation. I integrated such a Map Chart into a dynamic Excel Dashboard just recently and love how quickly everything is set up and how it visually stands out from other charts. Feel free to have a look at it :)

[namita]

Dhanyawad n Thank you so much ...I'm engaged in database related work in office n i didn't hv idea regarding this ...tday i got chance to learn from your video ...n m subscribing it .

[ngasefa]

Dear Computergaga, thank you for the clear and precise presentation. Can we put a legend for the color? How can readers know that the red-labeled countries have low subscribers?

[mattibeag]

Thanks for sharing. Is there a trick to save or export the map as an image file, without having to do a screenshot?

[davidegaudesi]

Incredibly useful, thank you so much

[eyitayoowolabi]

Thank you for this tutorial. I tried copying my generated map into word format but it does not work like it does in Excel. I am unable to hover around the map to show the country name and data. How ca I deal with this?

[mudassarrafique]

Maps option isn’t visible in my excel 2016
Plz help me in or recommend me your version
Thanks

[TheTrueBard]

I know this is an old video but I'm hoping to get some direction here: I am trying to help my city visualize problem areas. I have a spreadsheet with 23, 000 entries of call for service from our police dept all for the same city/state but different addresses. I tried importing this to this program (I am on Office 365) but the map comes up blank. Is there a newer program you can recommend to get this done?

[Der_Diskriminator]

I always get a error messege when i click on 3d map. "Colud not connect to bing...errorcode:10) + directx doesnt work. but i already installed multiple versions

[saliknazir]

What if we need to create a heat map of districts or states?

[NGAsefa]

Thank you for demonstrating. A couple of questions; can I use this add-in for country-specific data? How can we create (add) the color gradient legend?

[goldenvlad]

Hi, I'm trying to display some information in DRC and writing it as in the map Dem. Rep. Congo. I tried multiple other ways to write the country name, but it still doesn't display. Can you please suggest how to fix that?

[oldaculu]

Thank you so much. I am Olda student from East Timor. Currently I am studying Tourism Sciences at Tokyo Metropolitan University, Tokyo Japan. I have to create a distribution map about elements of attractions in my study case area. so, How to create the distribution map using Excel please? Thank you so much and I will really apreciate it.

[Alemv]

The video is very useful but in Mexico (where I live) the app doesn't work very well, I had troubles in the map, it was all gray, so I don't know if it is the availability here or it's just that I couldn't use it correctly

[esterobaybuddies]

I wish we could do it by zip code. Any ideas for how to do that?

[billionaireempire]

Hello, How can I embed this map on my website?

[michelledoes]

I had trouble because my "Store" icon was grayed out. All you have to do to get that to work, is convert your file to .xlsx format, close it, reopen it, and then it is active again.

[mprice]

How can I produce this using places within the UK?