Changing the Colour Gradient in the Heat map

I have received requests around how to change the colour gradient for the Geographic Heat Map (India) Excel template. In this quick tutorial, I will explain how to do it.

Step 1: Download and open the Geographic Heat Map (India) Excel Template. The map looks like the image below.

 

Geographic_Heat_Map_2

Step 2: Open Conditional Formatting menu and choose Manage Rules

Step2_ConditionalFormatting_Open

Step 3: Choose Sheet: Data

Step3_ConditionalFormatting_SheetData

Step 4: Click Edit Rule

Step 4 Edit conditional formatting rule
Step 4 Edit conditional formatting rule

Step 5: You should see the existing conditional formatting rule as shown below

Step5_Rule

Step 6: Change the colour for the minimum to your choice. This is the color that will be applied to the states with the lowest numbers in your data.

Step6_lowcolour

Step 7: Change the colour for the maximum to your choice. This is the colour that will be applied to the states with the highest numbers in your data.

Step7_highcolour

Step 8: Click OK

Step8_OK

Step 9: Click OK in the next dialog box. 

Step9_OK

Step 10: Back in the Geographic_Heat_Map worksheet, scroll down to row 40. Edit the text to reflect the colours you changed now. (You can enter any text here as you prefer.) This will be displayed on the map image so that those who read the map understand the colour gradient used.

Step10_Change_Legend

Your map image will update automatically.

Final Image of Heat Map of India
Final Image of Heat Map of India

Related free Templates

  • Canada – Heat Map – Excel Template
    $10
  • U.S. – State Heat Map – Excel Template
    $15
  • Australia – State Heat Map – Excel Template
    $10

42 Comments

  • Is there any way that I can reduce the font size of state name in the map?

    Reply
    • Please unhide hidden sheet ‘Data’. You can click on the state name boxes there and edit the font size. This would update the map in the first sheet.
      Best wishes.

      Reply
  • I have enter the text in row 40, colour of the map has changed, but colour gradient at right hand corner did not changed.
    Pl let me know , how it can be changed?

    Reply
    • Have you replaced the existing gradient text (row 41)? I am sorry if it is not row 40. There have been different versions of the file and it could have changed.
      I tried just now (changed row 41) and it updated on the map image.
      You can also open the hidden Data sheet where this text block is.

      Please let me know if it doesn’t work. Best wishes.

      Reply
  • These maps are really helpful!
    Can you please tell me how we can add values in the color gradient in the right corner?

    Reply
    • Thank you.

      Back in the Geographic_Heat_Map worksheet, scroll down to row 40. Edit the text to reflect the colours you changed now. (You can enter any text here as you prefer.) This will be displayed on the map image so that those who read the map understand the colour gradient used.

      Please let me know if I have misunderstood your question.
      Thanks.

      Reply
  • Thank you so much for this, you made me look so good in front of my employer. Was looking for this resource online for a presentation. Note: Will try recreate state level(district-wise) interactive chart for some states and share here when I am free.

    Reply
    • You are very welcome. I am glad that I could be of some help.

      Please share district level maps when you have them. They will be great. Best wishes.

      Reply
    • Thank you.
      You can add text boxes and point them (type = and select the cell where the data is) to each state’s data. I think it has to be manually done for each state.

      Reply
  • If you may please look into my requests for district level map and also if we may get multiple colour schemeing not only 3 colour shades, it will be great service to Non profit research organization like us.

    Reply
    • Yes, I do plan to publish district level maps in the future. However, it will take some time. Please e-mail me at indzara at gmail so that I can inform you when I have the district level maps. Which state(s) are you interested in?

      Reply
  • Its a great tool. Do you plan to go district level as your next project.
    Can we have a 4 color scheme in this as well?

    Reply
  • Heatmap is a great tool to design a webpage more interactive and creative to capture visitors attention. It do tells the problem area of the webpage which needs to be improved and redesigned. Thanks for sharing with us such a wonderful post.

    Reply

Leave a Reply

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