How to Create a Heat Map from Excel
If a website sells bus tickets, maybe their owners need to know the favorite destinations segmented by region of origin. A table may be useful, but a geographical map with heat zones is a lot better to see most popular regions.
These maps are useful to observe the interaction of two different regions: origin and destination. This can be used in transportation firms, travel agencies, or even to analyze the geographical performance of Adwords campaigns. Google's Geo Chart is a free and good option to create these maps.
Check this map with Spain's regions, see the HTML code to understand how to insert numeric values by region. The most recommendable thing is using the nomenclature ISO 3166-2 to identify each spanish region.
In this first example, Balearic Islands (ES-IB, in ISO 3166-2) have a value of 1, while Castilla y León has 8, so it becomes darker. Change the numbers inside the URL, and see how the map changes.
If you want to obtain this same map from Excel, there's a very simple solution: create a URL from a list of regions
If you want to get this map from Excel, there's a very simple solution: create the URL from a table with regions and numbers, and visit it from Excel. Download the complete Excel example.
A second option is using Phil Carto, which is must customizable than GeoChart, but harder to download, install and use. Some maps also have failures, since anonymous people design them.
This is the definitive PHP code to create a map in Google GeoCharts after adding values to the URL: