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
Need Hyderabad City heat map
Thank you for reaching out to us.
Currently, we do not have the Hyderabad Heat Map. We can take it as a customization project. Please write to us along with a copy of the Hyderabad map image at the below link for estimation:
https://support.indzara.com/support/tickets/new
Best wishes.
how can we remove names of the states in the heat map of India
Thank you for showing interest in our template.
You need to unhide the calculation sheet and select the text box containing the state name and delete the same.
Best wishes.
I want to show 3 numbers for a particular state. How can I do that
Thank you for showing interest in our template.
You can add a text box inside the required state from the Insert ribbon and select the text box without the cursor inside the textbox and type =| to get the referred cell value inside the text box. |
We take customization projects for a fee, please write to us at the below link for estimation if the above steps has to be processed from our end:
https://support.indzara.com/support/tickets/new
Best wishes.
I need to display some non-numerical data of each State in Map..please guide
Thank you for showing interest in our template.
We take customization projects for a fee as mentioned in the sent email. Currently, colors on the map are adjusted according to the value on the cell. Please share your requirement in the email whether you want the entered text in plain white map or along with the color. If you want along with the color, we need to add a column before the value for each state to get the text.
Best wishes.
Hi I am looking for heat MAP for Maharashtra
Thank you for showing interest in our template.
Currently, we do not have a heat map for Maharashtra. We can take it as a customization project for a fee. Please write to support@indzara.com with district wise Maharashtra’s map image for estimation.
Best wishes.
HI, Required Chennai Heat Map excel template
Thank you for showing interest in our template.
Currently, we do not have a heat map for Chennai with region wise split-up. We can take it as a customization project for a fee. Please share your requirement to support@indzara.com with a image of Chennai map with its region split-ups for estimation.
Best wishes.
you Download the india map in my Laptop
Great Work. Excellent job. This will surely help the community in visualizing data as they say picture speaks louder than the numbers. Keep up the good work. Can I request for Telangana district-wise heat map. Appreciate your team.
Thank you for sharing your valuable feedback.
Currently, we do not have the heat map for the Telangana. We will update you after we build the heat map for Telangana.
Best wishes.
Wonderful initiative, do you know anybody who has heat map at district level?
Thank you for sharing your valuable feedback.
Currently, we do not have the requested information.
Best wishes.
Dear team . excellent tool . can you help me with karnataka Heat Map
Thank you for showing interest in our template.
Currently, we do not have a district wise heat for Karnataka. We will update you once the same is available in our website. If you wish to prioritise this development for a fee, request to contact support@indzara.com for an estimation.
Best wishes.