The button for column chart is found under the INSERT TAB under the CHARTS SECTION.
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.
The procedure to insert a MAP chart are as follows:
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.
Follow the steps to reach the options.
Series option in the MAP CHARTS have three options. We’ll discuss them one by one.
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.
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.
This option shows the complete World Map.
The picture below shows the output of both the options.
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.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE