How to Draw a Map in Excel
Overview
We will be drawing a map in Excel, coloring specific areas based on given numbers. You can learn the details later by yourself, but just knowing this method can dramatically improve your visualization skills. Try including a custom-made map in your proposals or papers.
Guide
Step 1. Data Preparation
Prepare your data in Excel. It should be organized like the above, with place names and corresponding figures.
Step 2. Drawing
Go to Insert > Chart > Map
to insert a map chart. As shown, MS Bing will automatically find the locations on the map and color them according to the figures.
Step 3. Drawing a World Map
Naturally, you can also draw a world map.