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.
 
Geographic_Heat_Map_2
 

 

DOWNLOAD

If you would like to create editable map of india in excel free download the template (Telangana added in June 2014).
 


Please see below, a quick 5 minute demo of this template.

Geographic_Heat_Map_India_screenshot_2

How to use this 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
Showcasing_a_state
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 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 colour 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.

158 Comments

  • Dear team . excellent tool . can you help me with karnataka Heat Map

    Reply
    • 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.

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *