Geographic heat map – India (Excel template)
I was looking for a way to present/visualize state level data on an Indian map. I was not able to get that from the Bing maps application for Excel.
I am sure there are paid applications that might provide this functionality. I think this is a very basic need and I decided to prepare a simple template that can help create geographic heat maps for India.
India Heat Map Excel Template
Download
If you would like to create editable map of India in excel free download the India Heat Map Excel Template (Telangana added in June 2014)
Please see below, a quick 5 minute demo of this template.
How to use this India Heat Map Excel Template?
- Enter your (numeric) data in the data column and the map image on the right gets updated.
- Please make sure that the state (or union territory) names you enter in column A are spelled the same way as they are
- They are currently ordered alphabetically. However, you may choose to enter them in any order.
- You can print the sheet if needed
- You can copy the image and paste it in other applications such as Microsoft Word or PowerPoint
You can also use this template to showcase the position of one specific state.
For the illustration above, I entered a positive number (1) for Madhya Pradesh and deleted the data for all other States/UTs.
How is the heat map generated?
The India Heat Map Excel Template has a hidden worksheet where the outline of India and States/Union territories were drawn with the cells pointing to corresponding data. Conditional formatting has been used to create the heat map.
If you would like to change the color gradient, read this article.
If you know of better ways to do this or if you use any application to create such an excel map chart India heat maps, please share your thoughts.
179 Comments
Requre more uses Indian map in excel format
Thanks for your message.
We are in a process of releasing heat maps for Indian states.
Best wishes
Is there any way to showcase the numeric values as well within the map?
We would have to add the text boxes and display the numeric values from the input cells.
Best wishes.
we are trying to develop some heat maps all india level using our sales and other parameters, can you help us in this case .
please contact me if so .
Thanks for your message.
Due to high workload, we are not accepting any customized projects.
Best wishes
Excellent work Bro
Can we change the colour gradient from Green to Red?
Thanks for your message.
Please visit the following link for a tutorial on how to change the gradient color.
https://indzara.com/2013/08/changing-the-colour-gradient-in-the-heat-map/
Best wishes
Hi! Is a world heat map by countries available?
Thanks
Hello
The distribution by countries is not yet available.
Thanks
Hi. Is it available for Districts of India ?
Hello
We are planning to launch heat maps for all the states first. Then we might have the same for districts as well. However, it would take some time.
Best wishes
Hi. Using this template, but i do not want the graded color scale. I just want three colors – for above average (green), average (yellow) and below average (red). How do i do it?
Hello,
I came across your blogpost on Heat Map for India.
https://indzara.com/2013/04/geographic-heat-map-india-excel-template/
I will like to create a Heat Map for Nigeria. Please how do I go about it? How do I insert the image for map of Nigeria prior to inputting my data?
Thank you.
Thanks for your interest.
You can unhide a few tabs and make changes as per your requirements. We have used data on the internet extensively.
Best wishes
once i put all the data in for each state it corrupted the visual so that the colours and the outlines of the states just got all scrambled up. i’m using mac for excel.
when i opened up the original file the map was uncorrupted, but sometime after it just changed to look like a surrealist melted clock.
i look forward to being able to use this heat map at a district and even tehsil level 🙂
thanks.
Thanks for using the template.
Please ensure that you are using Excel 2013 or later versions on Mac. Also, sometimes if the formatting is altered, the file is not useable. Check the details and in case you are still not able to use the file, sent it to contact@indzara.com with a list of issues faced.
Best wishes