Geographic heat map – India (Excel template)

Posted on
Geographic Heat Map - India
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 heat maps like the one above, download the template (Telangana added in June 2014).


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

Geographic_Heat_Map_India_screenshot_2How 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 heat maps for India, please share your thoughts.

You may also be interested in...

Kerala Heat Map
Tamilnadu Heat Map
Activity Pattern Heat Maps

137 thoughts on “Geographic heat map – India (Excel template)

  1. How can I add more than 1 data column please help

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

  2. 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)

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

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

    1. Thanks for sharing your positive experience.

      We are yet to release heat maps for all countries.

      Best wishes

  4. Ladakh is not mentioned in the template. How can I include the union territory ladakh in the heat map?

    1. Thanks for your message.

      We will try to update the map in the next release.

      Best wishes

  5. West Bengal district heat map available?

    1. Hello

      We are in the process of developing the heat maps for all Indian states.

      Best wishes

  6. Can we have data labels?

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

  7. Hi,
    Its a fantastic tool for presentation,
    I just want to know how to change the colour gradient in the map.

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

  8. Is there a district level heat map available?

  9. Hi,
    This is really a great work. Can you please release the Karnataka map at district level for plotting in excel.

    Thanks!

    1. Thanks for your message.

      We are in the process of releasing heat maps for different states of India.

      Best wishes

  10. Can i have AP map in excel like Tamil Nadu

    1. Hello

      We are working on the heat maps for different states of India. We will release them soon.

      Best wishes

      1. thats great..waiting for the same.

        1. Thanks!!!

Leave a Reply

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