Excel has a number of data visualization capabilities and a geographic heat map in Excel is one way to make your data stand out.
Data visualization like charts, graphs and geographic heat map are very useful in data reports and presentation. They not only help you make sense of your data, but also help you to spot trends and make more informed decisions.
If geographic data is presented in tables, analyzing all the information manually and getting a clearer picture of the happenings in the various regions can be difficult. But by creating a geographic heat map, trends can be spotted easily across the locations and regions in the geographic data.
Geographic Heat Map in Excel Add-in
The Geographic heat map in Excel is an add-in available in Microsoft store. It automates how different values across different geographic locations can be visualized on a map.
To create a geographic heat map manually is not an easy task. You will need some extra graphic design skills to create one manually. But with the geographic heat map in Excel add-ins, you can easily create one.
So here is how to create a geographic heat map in Excel.
There are two major steps involved in creating a geographic heat map.
Step 1: Install the Add-in
1. Go to Insert tab -> Click on Store or My Add-ins
2. Navigate the Category to find the add-in or type Map in the search box.
#3. Select Geographic Heat Map and click the Add button beside it to install the add-in. This will take only a few seconds.
#4. In the dialog box that appears, click Continue
The geographic heat map add-in dialog box will appear on your worksheet.
Once the Add-in is installed, you will find it under Recently Used Add-ins in the drop down arrow
Step 2: Create Geographic Heat Map
1. Select Geographic Heat Map from Recently Used Add-ins list to start it.
2. In the pop-up screen that appears, click on Get Started button
This will take you to the Settings where you will format the map.
Select the cell range of the data to use, including the headers. From Choose Map options, select the map you wish to use, then select Regions Columns, Values Columns, and Colour theme.
Next, you will enter the Title, then tick the checkbox if you want to Show labels on the map and Choose legend from the drop down arrow selections.
3. Click Save.
Now that you have created the geographic heat map, it can be moved to any position in the worksheet.
If there are changes made to the data, the map will be updated automatically.
I hope you found this post useful. Kindly leave your thoughts in the comment section.
2,536 Replies to “How To Create a Geographic Heat Map in Excel”