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
How can I add more than 1 data column please help
Thanks for using our template.
You can insert a column in the template. Please ensure that none of the formulas or links are broken.
Best wishes
Hi
Thanks for making this avaiable, It is too good
Can I have only 03 colors i.e. If I want to restrict the colors to be highlighted for a range ( Red up to 6, Orange upto 8 and Green upto 10)
Thanks for your message.
Please review the steps explained in https://indzara.com/2013/08/changing-the-colour-gradient-in-the-heat-map/ to customize the color gradient.
Best wishes
Dear Guru,
I salute you for the good work. This is perfectly good work. Can you please release a Geographic heat map template for Tanzania (with all regions included)? Or it is only for India.
Thank you
Thanks for sharing your positive experience.
We are yet to release heat maps for all countries.
Best wishes
Ladakh is not mentioned in the template. How can I include the union territory ladakh in the heat map?
Thanks for your message.
We will try to update the map in the next release.
Best wishes
West Bengal district heat map available?
Hello
We are in the process of developing the heat maps for all Indian states.
Best wishes
Can we have data labels?
Hello
The name of the states is mentioned on the map. Hence, data labels are not required as we are not generating a chart.
Thanks
Hi,
Its a fantastic tool for presentation,
I just want to know how to change the colour gradient in the map.
Thanks for using our template.
Please review the article at https://indzara.com/2013/08/changing-the-colour-gradient-in-the-heat-map/ for changing the color gradient.
Best wishes
Is there a district level heat map available?
Hi,
This is really a great work. Can you please release the Karnataka map at district level for plotting in excel.
Thanks!
Thanks for your message.
We are in the process of releasing heat maps for different states of India.
Best wishes
Can i have AP map in excel like Tamil Nadu
Hello
We are working on the heat maps for different states of India. We will release them soon.
Best wishes
thats great..waiting for the same.
Thanks!!!