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

CONTENTS

CREATE 3D MAP CHART IN EXCEL

INTRODUCTION

A new chart style has been introduced in EXCEL named as a 3D MAP CHART.
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.
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.
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 3D MAP CHART in EXCEL.
3D MAP CHART lets us show our data on a globe and 3d settings. It is almost like a MAP CHART but 3D.
We can set the different layers over one another to see many data altogether. Let us see the steps to create a simple 3D MAP CHART first.
 

WHEN TO USE 3D MAP CHARTS

These charts are very appealing and creative as they are 3D .
Use these charts when you need to show any data related to different countries/regions, states, counties or postal codes. These types of charts are used to show GEOGRAPHICAL DATA to be precise.
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 TOURS SECTION.

3D MAP CHART BUTTON LOCATION
EXCEL:BUTTON LOCATION FOR INSERTING 3D MAP CHARTS

STEPS TO INSERT A 3D 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 3D MAP chart are as follows:

STEPS TO INSERT A 3D MAP CHART IN EXCEL:

    • Select the data.
    • Go to Insert> TOURS> 3D Maps>OPEN 3D Maps.
  •  This will create a all new window of 3D MAPS.
 
Let us understand the 3D MAP window.
3D MAPS INTRODUCTRY SCREEN
EXCEL:3D MAP FIRST SCREEN

LOOK AT THE PICTURE ABOVE.

There is a GLOBE at the center. It shows the countries and locations drawn on itself.

On the RIGHT SIDE are the data type choice box. The countries are already selected under the LOCATION.

Now for our data , we can add population or any other column [if we have].

TYPES OF CHARTS are given on the right side option box. We can have STACKED COLUMN,CLUSTERED COLUMN, BUBBLE CHART, HEAT MAP AND REGION.

In the picture, location is already marked as the chart has already acquired the location data.

Now, let us add our population data in the chart. Follow the steps.

  •  The default selected STACKED COLUMN OPTION box is open and location is already selected.
  • In the height field ,Click on ADD FIELD. A drop down with all the available fields will open. Right now , we have POPULATION only.
  • Select Population.
  • The population of the different countries will be shown as a 3D bar.
  • The following picture shows the population as a 3d bar on the 3d map chart.
HOW TO CREATE 3D CHART IN EXCEL EASILY
EXCEL:3D MAP OUTPUT

The bars’ height represent the population as per the data.

Similarly we can add more data by ADDING THE LAYER and repeating the same process.

Now , let us try changing the types of the charts available.

CHANGE THE TYPE OF CHART IN 3D MAP CHART IN EXCEL

As we already discussed that other than the STACKED COLUMN chart, we have few other options too such as clustered column, bubble , heatmap etc. So let us change the type of the chart in our 3D MAP CHART.

Follow the steps to change the chart type of the 3D Map Chart.

  • Remove the current STACKED COLUMN from the chart by clicking the X mark on the right portion of the HEIGHT FIELD as shown in the picture below. [ THIS STEP CAN BE SKIPPED TOO]
Remove Population field from stacked column
EXCEL:REMOVE THE POPULATION FIELD BY CLICKING ON THE CROSS
  • Select the chart type which you want to use in the 3D MAPS. For the example, we will use REGION VISUALIZATION.
  •  Click on the REGION VISUALIZATION ICON.
  •                                                  
  •  Now select the POPULATION  from the drop down in the VALUE FIELD.
ADD FIELD TO 3D MAP CHART
EXCEL:ADD POPULATION DATA IN FIELD
  • The chart will change to REGION STYLE and the countries will be colored with intensity showing the population.
3D MAP REGION WISE IN EXCEL
EXCEL:OUTPUT OF 3D MAP AFTER CHANGING THE CHART TYPE
  •  The picture above shows the output of the 3D MAP. We can see that the regions are filled with the colors of different concentration to show the value of the population.

CHECKING OUT THE LAYER OPTIONS IN 3D MAP CHART IN EXCEL

There are a few more options available in the 3D MAP CHART.
For example,CHANGING THE COLOR OF THE CHART, ADDING CATEROGIES CHANGING THE OPACITY , CHANGING THE OUTPUT CALCULATION ETC.
CHANG ETHE COLOR OF THE 3D MAP CHART
EXCEL: CHANGE THE COLOR OF THE 3D MAP CHART

1. COLOR INTENSITY VARIATION- It changes the intensity of the color which is filled in the regions.

2.OPACITY- opacity controls the transparency. Higher the opacity , lesser the transparency.

3. CHOOSE COLOR- Choose the color of the chart.

4. CHOICE OF CALCULATION-EXCEL provide us the option to show one of the many types of calculations in the 3D map such as sum, average, count [ not blank], count[unique], maximum and minimum.

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

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: