Changing the Colour Gradient in the Heat map

Posted on

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

Step 3: Choose Sheet: Data

Step3_ConditionalFormatting_SheetData

 

Step 4: Click Edit Rule
Step4_Edit_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

30 thoughts on “Changing the Colour Gradient in the Heat map

  1. Hi ! Thank you for this absolutely useful map! Is there any way to show the states as white for the states where data is not available?

    Thanks

    1. Thanks for using our template.

      Please unhide the sheets and you can change the colors.

      Best wishes

  2. Thanks. You have explained it so nicely, that one could understand it instantly. You have taken pains to capture screenshots that illustrate how this needs to be done. Wonderful and Awesome. Thanks a lot. Keep up the good work.

    1. Thanks for your positive feedback!!!

  3. Hi, Can I add value also in the respective state also.

    1. Hello

      You can change the value as well.

      Best wishes

Leave a Reply

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