Pages

▼

Thursday, August 15, 2013

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 (India) Excel Template

Step 2: Open Conditional Formatting menu and choose Manage Rules

Geographic Heat Map (India) Excel Template - Step 2 - Conditional Formatting
Step 3: Choose Sheet: Data
Geographic Heat Map (India) Excel Template - Step 3 - Choose Sheet: Data
Step 4: Click Edit Rule
Geographic Heat Map (India) Excel Template - Step 4 - Click Edit Rule 
Step 5: You should see the existing conditional formatting rule as shown below
Geographic Heat Map (India) Excel Template - This is the existing rule
Step 6: Change the colour for the minimum to your choice. This is the colour that will be applied to the states with the lowest numbers in your data.
Geographic Heat Map (India) Excel Template - Step 6 - Choose a different color for Minimum 
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.
Geographic Heat Map (India) Excel Template - Step 7 - Choose a different color for Maximum
Step 8: Click OK
Geographic Heat Map (India) Excel Template - Step 8 - Click OK
 Step 9: Click OK in the next dialog box.
Geographic Heat Map (India) Excel Template - Step 9 - Click 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. 


Geographic Heat Map (India) Excel Template - Step 10: Type the new Colour Gradient

 Your map image will update automatically. 
Geographic Heat Map (India) Excel Template - After changing Colours

9 comments:

  1. heat mapSeptember 20, 2013 at 8:02 AM

    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.

    ReplyDelete
  2. ShadowSeptember 23, 2013 at 4:57 AM

    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?

    ReplyDelete
    Replies
    1. UnknownSeptember 25, 2013 at 7:03 AM

      Thank you. The current gradient scheme is more flexible. 4 Color Scheme can be set up if needed. Are you familiar with conditional formatting?

      Delete
  3. ShadowSeptember 23, 2013 at 5:00 AM

    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.

    ReplyDelete
    Replies
    1. UnknownSeptember 25, 2013 at 7:02 AM

      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?

      Delete
  4. jtrajanJune 18, 2014 at 8:19 PM

    Its a good source in deed.
    I wanna add values on each state?
    How to do that ?

    ReplyDelete
    Replies
    1. UnknownJune 22, 2014 at 7:31 AM

      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.

      Delete
  5. jtrajanJune 18, 2014 at 10:56 PM

    Hi..
    I also wish to know is there a heat map for Regionwise for India ?
    Thanks in advance

    ReplyDelete