How to create a Thematic Map in Microsoft Excel?

280

By: Bernardus Ari Kuncoro

A few months ago I have tried to make a map graph with Excel. It will show you a graph that shows a map, in which the different colors represent the numbers or measurements.

The Jakarta Map Graph

Preparation

What do you need?

  1. Microsoft Excel (version 365 or 2016 and up)
  2. BPS Dataset

Instructions

  1. Download BPS Data. The link is on preparation.
  2. Open a new file with Microsoft Excel
  3. Clean the dataset
    1. Find and replace a space with empty characters
    2. Find and replace comma with dot (make sure the decimals convention is using dot, instead of comma).
    3. Remove the x character in one of the cell
    4. Insert > Table (make sure that you have a header in our table).
  4. Format the location column (in this case is provice) by selecting Province, Data, and Geography
  5. Select provinsi column, in this case the population density. Then Insert ? Maps.
  6. Give some details in the graphic for setting the density colors. In this case, you can use right click on the map, format data series and change gradient style with diverging. Green (50). Yellow (100). And, red (100).

To be clear, you can watch the video below. I have edited the video speed, so it will be packed with IG Reels (30 seconds). Enjoy!

Wanna support me?

Follow by Email
LinkedIn
Share