Hello friends, today i am going to show
you
how you can insert a colorful and
informational map in Microsoft Excel
and in PowerPoint. For this, you will need
either 2019
or Office 365, latest version.
In Excel, I have typed all the 28 states
and 8 union territories of India with
their first official language here.
Let me select all the data of both
columns,
go to insert and in the "Chart Tool" you
will see
Map, and there select the only option
Filled Map and you have your map of India
color-coded as per the data on the
second column.
Right-click on the map and click on
format data series.
In this format pane, under map labels,
select show all. Now the map will show
the names
of all the states as per the first data
column.
Next, go to map area and select world.
And the Indian map will show among the
world map.
Next select multiple countries/regions and the map will show you the
Indian map with the Asian region.
Next select country/region,
and it will only show the Indian map. If
some states have no
data, you can opt for "only regions with
data"
or you can select "Automatic". You can
tweak the map from
map projection. Try out options given
there
and choose the best map option as per
your liking.
Automatic works best for most cases.
Let us now have a look at a different
sets of data.
In this sheet, I have all the countries
on the left
ranked as per the Goodness Index of 2018 data.
Here India is at 44th position.
I have a total of 154 countries
indexed here. let me simply click on any
cell of this data,
go to insert and click on the map in the
chart tools
and select filled map and the world map
appears
magically.
Right-click on the map area and select
format data series.
Under series options and map labels,
select show all
and the name of the countries will be
shown.
Then in the map area select only regions
with data
and the countries which does not have
any data
will not be shown.
Let us now select diverging 3-color
and select minimum, midpoint and maximum
color range
to differentiate the various data as per
the country.
Select some contrasting colors.
Next right-click on the map area again
and this time
choose, add data labels and the data on
the second column
will be added to the map. India is far
ahead of china
in Goodness Index. let us now see
how we can add a map in PowerPoint. In a
blank slide,
go to insert, and click on chart. Select
map
on the left of the pane, and select Filled
Map. Click ok. By default, it will open an
excel file with 12 countries which in turn will
open the world map.
But you can change the way the map looks.
Let me delete all the data from this
excel file,
and copy my data of the India and Indian
languages
in here. But this chart does not look so
colorful.
Let me add a third column in the excel
with just 1 to 36 serial number.
Next right click on the map and click on
Select Data. Modify the chart data range
as per your data in the excel sheet. For
me,
the range is from A1 to C36.
Click ok, and there, you have a beautiful
Indian map,
colored as per first official language
of the states.
Now right-click on the map and select
Format Data Series in the map labels. Select
Show All, to see the names of the states.
Next right-click on the map again and
this time,
choose Add Data Labels and the chart
will show the languages,
that are spoken on these states. Let me
add a blank slide.
Go to insert and chart and select Map.
Now in this chart, let me copy the
Goodness Index of the countries
data. Again right-click on the map
and modify the Chart Data Range A1 to
B154. Click ok,
to have all the countries color
populated. You can now close the excel
data file.
Right-click on the map and go-ahead to
the format data series.
Bring in map labels, and play with series
colors.
In the map projection select Mercator,
and there is a huge distortion
in the size of countries. Automatic is
a better solution for this map.
Let me show you another option of adding
a map of a smaller area.
In PowerPoint, this option is best, if you
want to point to a particular location
in a country. Click on insert and click
on Get Add-ins.
In Office Add-ins, Store, search for map
application.
Select the OfficeMaps, and click Add. I
have already downloaded
and added this application in My Add-ins.
Click on the Open OfficeMaps. Click on
Get Started, if you are using it for the
first time. Next,
enter a location in the search bar and
select the option you want.
Let me choose Mumbai. Next click on
settings,
select map size as 16:9 (landscape),
select marker size and color, Include
Address Information,
ON, and then click on Insert Map.
There, you have the location map of
Mumbai
in your PowerPoint slide. I hope you liked
the content of this video. Do check out
my other videos
on this channel. If you want to see more
videos like this,
Subscribe and click on the Bell for all
the notifications.
Please hit like and leave a comment
below. I will be back soon.
[Closing Music]
