Site icon INDZARA

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.

 

Step 2: Open Conditional Formatting menu and choose Manage Rules

Step 3: Choose Sheet: Data

Step 4: Click Edit Rule

Step 4 Edit conditional formatting rule

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

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.

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.

Step 8: Click OK

Step 9: Click OK in the next dialog box. 

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.

Your map image will update automatically.

Final Image of Heat Map of India

Related free Templates

Exit mobile version