Hello and welcome to this video tutorial from computer gaga dot com
In this video, we are going to look at how to create a geographic heat map by using a free Excel
add in. So I have this data on my spreadsheet where I have a list of countries and then a number
of online training subscribers. And I would like to see this data visually over the image of a world map using
a typical rag status, a red to green color scheme. So where I have the most subscribers will be green working its way
down to red. Now there is a brilliant free add in for this
I am in XL 2013 at the moment. So I'm going to need to click on my insert tab and then click on my store
button so that I can go and find this add in that we need
So we're going to need to install this for the first time with an extremely quick and simple process
Now, in this apps area, I've got multiple categories to find what I'm after
I also have this search box. So I'm going to just type in map in there and search for any apps that have the word
mapping and geographic heat map is the first one that appears. So it will allow you to visualize data across geographic
locations. Let me click the add button and just give that a chance to load
And it's a very, very simple add in here. It is, we just click on our get started button and simply answer the questions
So if I click on my select data button, and the first thing I'll do is highlight my range of data
Now, this must include the headings. So I select that range there
A two to B nine and click. OK, then I choose what map I want
Now at the time of recording this video, we just have the options of the United States and also a world map
And I want the world map, hopefully over time, we may have
you know, more maps added to this. Then it will ask me which columns I want now for the regions and it picks up the
column headers I want country and for the values I want number
it will ask me for a color theme, red to green, green, to red or gray scale
I want red to green. So red with the small numbers working up to green with the big numbers
And then for a title, I will type number of subscribers and simply click on save and
there we have it very fast. That is my geographic heat map
So I can see the darkest green here is for the United States
And as you hovy yourself over the map, you can see it, tell you what each is
There's Egypt, there's India, here's Australia down here. So you can see Australia is in an orange but in a dark orange for Canada because
it's below there. So it's getting closer to the color of red
uh visualized by Egypt and even darker for Argentina there. So he's doing that red two kind of green scale
Now I can move this map around by simply be hovering over the edge of it and just like an image
you can click and drag the map. I can resize it with the corner arrows
And this map will also update if you change the values on your spreadsheet
So if I clicked in the number of subscribers for Australia and maybe update that to 2200 subscribers
from that region from that country, then as soon as I press enter
it will update on my map. So now that is my best country but only a little bit more than the United States
So they're both green and and but you may be able to tell it's a slightly darker green for Australia
As you have Rovi, you get this data label. Very, very nice
So this is this completely free app, this geographic heat map. It could be a wonderful addition to your reports and
to your dashboards. If you have to monitor your data, for example
your sales across the globe, this could add a real nice visual element to your existing reports or
to your even your new reports, they may create off the back of it
I hope you found this video useful. Please check out some of our other videos on our youtube channel and come check us out at computer gaga dot com