How to create Choropleth Map in Excel in Just 3 Minutes

Excel mapping!

9

Impress your Colleagues, Clients, Team Leads or a class presentation with the customised Choropleth map. Furthermore what’s interesting is that creating choropleth map in excel doesn’t require you to be a cartography expert, it is as simple as ‘drag and drop’ and in just 3 minutes.

A picture is worth a thousand words. A simple graph is a way better representation than just random numbers. With the same note, think of visualising all the country based statistical data in the form of choropleth maps, which will promote the understanding of statistical data with accurate and faster decision-making.

Step 1: Input the required country specific data

Step 1: 

Open a New Excel and feed the necessary data. In this example, Country and its Population are the base data.

 

 

 

 

Step 2:

Click on the ‘Insert’ tab, where you will find ‘Store’ in ‘Add-ins’ Section as shown below. Click on the ‘Store’ icon and search for ‘Geographic Heat Map’ and click on ‘Add’.

 

Step 2: Add the Geographic Heat Map

Step 3:

Click on ‘Get Started’ and you are good to go. After which select the appropriate map based on the data you are mapping for. For this example, it will be a ‘World’ map. Now click on ‘Select Data’ and select both the columns i.e., Country and Population.

Step 3: Select the appropriate map and the data.

Step 4:

The ‘Regions’ and ‘Values’ are selected automatically based on the ‘Select Data’ input. Adjust the ‘Colour Theme’ to move from ‘Green to Red’ or ‘Red to Green’. In this case, ‘Green to Red’ is the preferred colour scheme for higher population we prefer red and green for the lower. Give suitable title for the map and click on ‘Save’.

Step 4: Select the suitable colour range

Step 5:

Map will be generated in the range of green to red, from lowest to highest population.

Step 5: Generated heat Map for Population data

Step 6:

Now Copy and Paste the Choropleth Map in ‘Word’ and then save it as a Picture and inspire your peers every time, by your customised heat map!

Step 6: Final Output

For better understanding of choropleth map, random numbers are included to visualize the colour change based on the values.

Choropleth map generated with random numbers
  • Handy Chandra

    I do not have add-ins in my excel. how can I add it?

    • Vinithra Rajendran

      If you are using 2007 or 2010 version there are two options
      1. You can find the add-ins under the ‘Tools’ option.
      2. Click the office button, and then click the file tab and go to options where you will find the add-ins button.

  • Pingback: How to create Heat Map in Excel in Just 3 Minutes – GeoNe.ws()

  • Lkhagvaa

    thank u soooooooo much. i could do that. but before i could it i spent 2 hours

  • Erin Mears

    I am a geo teacher in Ottawa ON Canada and would LOVE to use this with my gr 9 students but cannot find the “add-ins” in my Excel program. What version of Excel do I need to be able to access this?

    • Vinithra Rajendran

      If you are using 2007 or 2010 version there are two options
      1. You can find the add-ins under the ‘Tools’ option.
      2. Click the office button, and then click the file tab and go to options where you will find the add-ins button.

  • Pingback: Anything but bars: The 10 best alternatives to bar graphs • Hypsypops Design Co.()

  • Pingback: Anything but bars: The 10 best alternatives to bar graphs()

  • Geoff

    Hi, I would like to produce a choropeth for data I have been working on relating to Somalia’s 18 regions. I use Excel 2016 and have access to shapefile data for the 18 regions. Any advice on how I can do this simply and at low cost? Thanks, Geoff