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 reading the text.
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 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 CHART 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

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

gyankosh060309@gmail.com

Like this:

Like Loading...

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: