PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

CREATE MAP CHART IN EXCEL

INTRODUCTION

A new chart style has been introduced in EXCEL named as a MAP CHART.
As we all are familiar that charts give us a visual representation of the various data. It is a scientific proven fact that we understand better and faster if something is presented visually rather than the theoretical presentation.
MAP CHART facilitates us with the option of showing the data of different geographical regions of the earth.
We can show the data related to countries/regions, states, counties or postal codes.
The complete world map will be shown and it’ll take help of the bing [Service of MICROSOFT] to locate your mentioned place. The data against it can be shown in various ways.
 
In this article we would learn to use the MAP CHARTS in EXCEL.
 

WHEN TO USE MAP CHARTS

These charts are very appealing and creative.
Use these charts when you need to show any data related to different countries/regions, states, counties or postal codes.
For example, population of the world, crime rate, education, temperatures, any data.
The good thing is the different options which we get with this map.
 

BUTTON LOCATION FOR INSERTING COLUMN CHARTS

The button for column chart is found under the INSERT TAB under the CHARTS SECTION.

CREATING MAP IN EXCEL
EXCEL:BUTTON LOCATION FOR INSERTING MAP CHARTS

STEPS TO INSERT A MAP CHART IN EXCEL

EXAMPLE DETAILS

We can demonstrate a chart by the use of an example.

We will find out the population of the few countries in the world. Let us say our table is the following one.

The details are fictitious. Don’t go by them.

COUNTRYPOPULATION
US1000
India1500
FRANCE1200
UK800
GERMANY900
 

The procedure to insert a MAP chart are as follows:

STEPS TO INSERT A MAP CHART IN EXCEL:

    • Click anywhere on the table.
    • Go to Insert> Charts> Maps>Filled Maps.
  •  The map will be created showing the population with a color.
 
 The complete process is shown in the animated picture below.
EXCEL:STEPS TOCREATE A MAP IN EXCEL
After the map creation, we can go for some changes if we want. For example the changes in color etc.
Let us try to change the color to different options.

CHANGE THE COLOR OF THE MAP CHART IN EXCEL

Now let us see how we can change the color of the map chart in excel.

The one we saw in the above column is a 2 color chart.

Now we will try a three color chart. Follow the steps to change the color scheme of the chart.

  •  Right Click on the chart and select FORMAT PLOT AREA. If we double click the chart, it gets open by that gesture too.
  •  Click the DROP DOWN as shown in the picture below and choose SERIES POPULATION as we are going to set the colors according to the series.
CHANGE THE COLOR SCHEME OF MAP CHART IN EXCEL
EXCEL:OPEN THE FORMAT PLOT AREA OPTIONS
  •  After selecting the series we’ll get the following option. -SERIES OPTIONS AND SERIES COLOR
  • Choose SERIES COLOR
choose series options
EXCEL:CHOOSE THE SERIES COLOR OPTION
  •  After selecting the series we’ll get the following option. -SERIES OPTIONS AND SERIES COLOR
  • Choose SERIES COLOR.
  • After choosing the SERIES COLOR, we’ll find the new options of choosing a 2 color scheme or 3 color scheme.
  • Choose 3 color scheme as 2 color scheme is already chosen.
CHANGE THE COLOR OF MAP CHART IN EXCEL
EXCEL:CHOOSE THE COLORS OF THE CHOICE
  •  The three color scheme gives us the option of choosing the different colors for lowest value , number or percentage through the middle value, number or percentage to the highest value, number or percentage.
  • Choose the colors of the choice and the chart would change its colors as per the choice.
  • If again want 2 color scheme. Repeat the procedure but choose 2 color scheme.
  • The only difference is the present of middle value. We can choose two colors in this whereas three colors in the other scheme.
  • Our colorful chart is ready. Here is the output.
MAP CHART IN EXCEL BEST
EXCEL:FINAL OUTPUT

ADDITIONAL OPTIONS IN MAP CHART IN EXCEL

There are a few more options available in the MAP CHART.
For example, Adding labels to the countries, Setting the map projection and setting the map area.
 

 Follow the steps to reach the options.

  • Right Click on the chart and select FORMAT PLOT AREA. If we double click the chart, it gets open by that gesture too.
  •  Click the DROP DOWN as shown in the picture below and choose SERIES POPULATION .
 
CHANGE THE COLOR SCHEME OF MAP CHART IN EXCEL
EXCEL:OPEN THE FORMAT PLOT AREA OPTIONS
  •  After selecting the series we’ll get the following option. -SERIES OPTIONS AND SERIES COLOR
  • Choose SERIES OPTIONS.
CHOOSE SERIES OPTIONS IN MAP CHART
EXCEL:CHOOSE THE SERIES OPTION

Series option in the MAP CHARTS have three options. We’ll discuss them one by one.

SETTING MAP PROJECTION IN MAP CHART IN EXCEL

The first option in the SERIES OPTIONS is setting the map projection.

MAP PROJECTION gives us the various types of projections available as the options in Map chart.

The options are MERCATOR, MILLER and ROBINSON. We can choose any of them.

By default AUTOMATIC OPTION gives us the best choice as per algorithm in EXCEL.

MAP PROJECTION IS THE WAY TO LAY THE GLOBE ON A FLAT PLANE. THERE ARE VARIOUS WAYS TO DO SO. THE MENTIONED THREE WAYS ARE ONE OF THEM.

Picture below shows the outputs of three different map projections available in the EXCEL.

Visually, you can choose the one you want.

SETTING MAP PROJECTIONS IN MAP CHART
SETTING MAP PROJECTION IN MAP CHART

SETTING MAP AREA IN MAP CHART IN EXCEL

MAP AREA can be chosen as per the need.

We have got two options for the MAP AREA [other than the automatic which Excel decides itself].

ONLY REGIONS WITH DATA:

This option will zoom the map and only focus on the region with the data. For example, if the data pertains to only one country, that country will be zoomed in and only the country map will be shown.

WORLD:

This option shows the complete World Map.

The picture below shows the output of both the options.

SETTING MAP AREA IN CHARTS
SETTING MAP AREA IN MAP CHARTS IN EXCEL

SETTING MAP LABELS IN MAP CHART IN EXCEL

The final option available for formatting the MAP CHARTS IN EXCEL  is setting the labels on the maps.

Excel offers Three options for labels.

NONE: No labels.

BEST FIT ONLY: Label only those countries where the label fits easily. Look at the picture below , the European countries could not accommodate the label, so Excel didn’t name them.

SHOW ALL: Put label in all the locations whether the label fits or not. The picture shown below can be examined to see that European countries could not accommodate the name even then Excel tried to give one.

SETTING MAP LABELS IN EXCEL
SETTING MAP LABELS IN MAP CHART IN EXCEL

OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]