One of the smartest ways of visualising data is using heat map method. According to this, we use colour sets and shades in order to show individual data points within a data set. And if you want to visualise geographical values than you will need to use geographic heat map. If you are looking for a Italy Heat Map, this Excel template does the job!

Why Do We Make Use Of Heat Maps In Order To Present Our Data?

By technological improvements, now we are able to reach more data and information. Unless, you are able to tell or present your data in hand, it means nothing for your audience. So, your data is valuable as long as you can tell it to others. It’s indispensable to find out smarter ways for telling and presenting our complicated data. That’s why, data presentation and data visualisation through geographic heat maps has become an effective solution for presenting sophisticated data sets.

Thanks to heat maps, you will see that your audience is able to capture quickly, what you are telling or presenting to them. Also, it is more professional to use heat maps for your presentations instead of presenting a set of raw data without handling or processing it. Take look at this population distributon in Italy:

In daily life, we make use of geographic heat maps frequently. Mainly, business world uses geographic heat maps for their presentations and daily reports. Another area where geo heat maps are being used is meteorology science. Sociology, economics, politics, medicine are other fields that we use geo heat maps regularly.

That’s great but how can I create a Heat Map in Excel?

As we mentioned above, it’s a very easy and smart way for data presentation, however it is not as easy to create a geographic heat map from scratch. The development of this tool in Excel consists of 4 main parts:

Create/Gather Visual Assets

Set up the Data Table and Name Shapes

Create the Legend and Color Scale

Automate with VBA

As you see, it takes a lot of time and effort to make a heat map on your own. Therefore, we have created ready-to-use geo heat map templates for continents, countries and cities, in Excel. Geographic Heat Map for Italy at region level is one of these heat map templates.

In 3 simple steps you can create Italy Heat Map in this template:

Step: Paste/Type your data from your own spreadsheet

Step: Choose your limits for data ranges

Step: Choose your color set and click the button!

Check the VIDEO below to see how Italy Heat Map Generator works:

Thanks to this template, you will see that your Italian heat map gets generated within minutes!

Italy Heat Map Generator Excel Template Features:

Fully editable Italy map including 20 states

Easy to use and nice design

5 Premade color sets to choose from (you can even modify as you wish)

Export to PDF feature

Clear on sheet instructions (with turn on/off function)

Print Ready

Includes VBA code and macros

Compatible with Excel 2007 and later

On-sheet instructions in the template will guide you while using the template. We have used population data just for illustration but you can easily put your own data and prepare your heat map:

You can print the results or export to PDF as you like.

Template offers 5 different color palettes to choose from. Additionally, you can change the colors and choose from your own defined palettes: