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
Did you like the post? Read more and subscribe to our monthly newsletter!
#GeoDev
Next article
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:
Credits: NASA EARTH OBSERVATORY
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:
Credits: NASA EARTH OBSERVATORY
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:
Credits: NASA EARTH OBSERVATORY
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:
Credits: NASA EARTH OBSERVATORY
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!
