How to draw a map chart on Excel

The chart types on Excel will be used to represent data tables, such as column diagrams, pie charts, cone charts, etc. And in the recent Excel 2019 version, users have to add the map chart form to Country locations displayed in the map. This map chart type can be used to compare data between geographic areas such as countries in the world, provinces in a region, etc. The following article will guide you how to create a chart. map on Excel. Note to readers, to create a map chart, the computer needs to connect to the network. After creating, you can still see the map without a network connection.

1. Create Excel charts that automatically update data with these three simple steps
2. How to draw charts in Excel
3. How to draw a straight line, draw an arrow in Excel

Instructions for drawing map charts on Excel

We have a GDP chart between different regions as shown below.

How to draw a map chart on Excel Picture 1

Step 1:

Users click on any cell in the data table on Excel. Then click on the Insert tab and then select the Maps item . Click on the map image as shown below.

How to draw a map chart on Excel Picture 2

Step 2:

It will then display the map chart as shown below. The chart automatically adjusts colors based on data from high to low.

How to draw a map chart on Excel Picture 3

Step 3:

After obtaining the chart the user can edit the design for the chart. At the Format tab of the Chart Styles we will have different types of charts. Click on a new chart type.

How to draw a map chart on Excel Picture 4

Map chart will be changed as below.

How to draw a map chart on Excel Picture 5

Step 4:

In the Change Colors section we can choose the colors displayed for the areas on the map.

How to draw a map chart on Excel Picture 6

The color of the area will change according to the color we have chosen.

How to draw a map chart on Excel Picture 7

Step 5:

After editing the new format and design for the map, users need to display the names of the features on the map. Click on the Format tab and then click on Format Selection .

How to draw a map chart on Excel Picture 8

Right after that on the right of the interface displays the Format Plot Area frame, click on the triangle icon and select Series GDP .

How to draw a map chart on Excel Picture 9

Step 6:

Click on the column chart icon to edit the map.

How to draw a map chart on Excel Picture 10

Display options at Series Options . Click on the Map labels item and select Show all .

How to draw a map chart on Excel Picture 11

In case of displaying yellow notification Map charts need geographical data such as country / region, state / province, county, or postal code. Check your data and try again as shown, the features in the data table will not be created. This error may be because your geographic location is too small like a district or a commune, .

How to draw a map chart on Excel Picture 12

The result will display the map with the location name as shown below.

How to draw a map chart on Excel Picture 13

Above is how to create a map chart in Excel version 2019. With this type of map chart, the data table will be more intuitive, more vivid when displaying geographical locations according to the data table of user.

See more:

1. Word 2013 Complete Guide (Part 17): Drawings and how to create effects for drawings
2. Tutorial for Word 2016 (Part 18): How to add Shape shapes
3. Word 2013 Complete Guide (Part 3): How to store and share documents

I wish you all success!