#GeoDev #Ideas

How to create Choropleth Map in Excel in Just 3 Minutes

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.

Choropleth Map in Excel

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!

Choropleth Map in Excel

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 in Excel

Choropleth map generated with random numbers

Did you like the post? Read more and subscribe to our monthly newsletter!

Say thanks for this article (1)
The community is supported by:
Become a sponsor
#Events #Fun #GeoDev #Ideas
Join 6th CASSINI Hackathon. Innovating with Space Technology for International Development & Humanitarian Aid
Geoawesomeness Team 09.9.2023
#Business #Featured #GeoDev
Geo Addressing Decoded Part 2: Beyond Coordinates – Exploring the Depth and Impact of Geo Addressing
Aleks Buczkowski 05.2.2024
#Featured #GeoDev #People
MapAction looking for volunteers to unlock information management barriers in humanitarian sector
Alex Macbeth 10.31.2023
Next article
#Environment #Fun #Ideas

Top 5 Satellite Images of Rivers

An art that flows

Rivers were the source of civilisation that gave life along the path it flowed. Over time, few rivers have changed their path, few disappeared, few dried up but very few rivers form an artwork by itself. Below are such artworks captured from Space. They are some of the amazing satellite images of rivers across the globe.

Dnieper River:

Credits: Tim Kopra/NASA

The fourth longest river of Europe captured by Astronaut Tim Kopra while orbiting Earth as part of the Expedition 36 and 37 missions. One can easily take this for an amazing masterpiece of an artist. This marvellous appearance of the river is attributed to the fact that it owns more than 32,000 tributaries.

Acquired: 04 Jan 2016

Indus Delta:

Korangi, or Korangi Town, is part of the Karachi metropolitan area of coastal Pakistan. This photograph taken by an astronaut from the International Space Station highlights the contrast between the highly urbanized and industrialized Korangi area and the dense green mangrove forests and waterways of the Indus River Delta to the south. Away from the river delta, vegetation cover disappears rapidly to the northeast.

Acquired: April 20, 2013

Zambezi River:


The Zambezi River forms part of the border between Zambia and Namibia, where the Caprivi Strip juts eastward from the rest of Namibia. Flowing down a gentle gradient in this region, the Zambezi often spills onto floodplains during the rainy season, with water levels peaking between February and April.

Acquired: 31 March 2013

Danube River:


The Danube Delta has been home to human settlements since the end of the Stone Age (the Neolithic Period), and the ancient Greeks, Romans, and Byzantines all built trading ports and military outposts along this coast. Today, the border between Romania and Ukraine cuts through the northern part of the delta. The area is a United Nations World Heritage Site, both for its natural and human history, and for the traditional maritime culture that persists in its marshes. All the while, the landscape has been shaped and re-shaped by nature and man.

Acquired: 5 Feb 2013

Rio Mamore:


What causes rivers to meander, and why do some meander more than others? These questions have been the subject of research for more than a century, and several hypotheses and studies have focused on the role of sediments. The Amazon Basin—free of engineering controls and containing a wide range of sediment loads—provides a natural laboratory in which to investigate the relationship. Whatsoever, each meandering keeps adding to the beauty of the river.

Acquired: 13 July 2014

At the end all these rivers keeps us inspired and fascinated, making us fall in love with the BEAUTY OF EARTH and its features again and again!

Read on