How to create Maps in Microsoft Excel and PowerPoint
How to create Maps in Microsoft Excel and PowerPoint
A short video of How to create Maps in Microsoft Excel and PowerPoint. Apologies for the robotic voice.
#MSExcel #PowerPoint #Howto
Recommended videos you must not miss :
How to create PowerPoint Parallax Effect - Channel Intro
Easy and Beautiful Morph Transition • วิดีโอ
Magic of Morph Transition - PowerPoint How To - Prezi Effect • วิดีโอ
Morph Transition Photo Album in PowerPoint • วิดีโอ
How to Create \u0026 Animate Gears in PowerPoint • วิดีโอ
How to Create Broken shape \u0026 Broken Text • วิดีโอ
How to Create 3D Sphere and 3D Shapes in PowerPoint • วิดีโอ
How to make a bubble and animate it • How to make Bubble Animation in Power…
Content
3.738 -> and 8 union territories of India with
their first official language here.
8.538 -> Let me select all the data of both
columns,
13.818 -> go to insert and in the "Chart Tool" you
will see
17.258 -> Map, and there select the only option
Filled Map and you have your map of India
24.378 -> color-coded as per the data on the
second column.
28.297 -> Right-click on the map and click on
format data series.
32.617 -> In this format pane, under map labels,
select show all. Now the map will show
38.777 -> the names
of all the states as per the first data
42.378 -> column.
Next, go to map area and select world.
46.777 -> And the Indian map will show among the
world map.
51.897 -> Next select multiple countries/regions and the map will show you the
57.418 -> Indian map with the Asian region.
Next select country/region,
63.177 -> and it will only show the Indian map. If
some states have no
67.098 -> data, you can opt for "only regions with
data"
70.778 -> or you can select "Automatic". You can
tweak the map from
75.497 -> map projection. Try out options given
there
78.857 -> and choose the best map option as per
your liking.
82.378 -> Automatic works best for most cases.
87.497 -> Let us now have a look at a different
sets of data.
91.177 -> In this sheet, I have all the countries
on the left
94.217 -> ranked as per the Goodness Index of 2018 data.
98.378 -> Here India is at 44th position.
I have a total of 154 countries
104.938 -> indexed here. let me simply click on any
cell of this data,
109.658 -> go to insert and click on the map in the
chart tools
113.258 -> and select filled map and the world map
appears
118.869 -> Right-click on the map area and select
format data series.
123.509 -> Under series options and map labels,
select show all
127.589 -> and the name of the countries will be
shown.
132.149 -> Then in the map area select only regions
with data
136.39 -> and the countries which does not have
any data
141.202 -> Let us now select diverging 3-color
and select minimum, midpoint and maximum
147.681 -> color range
to differentiate the various data as per
151.282 -> the country.
Select some contrasting colors.
158.882 -> Next right-click on the map area again
and this time
162.802 -> choose, add data labels and the data on
the second column
166.722 -> will be added to the map. India is far
ahead of china
170.401 -> in Goodness Index. let us now see
how we can add a map in PowerPoint. In a
176.961 -> blank slide,
go to insert, and click on chart. Select
181.282 -> map
on the left of the pane, and select Filled
184.162 -> Map. Click ok. By default, it will open an
188.162 -> excel file with 12 countries which in turn will
191.922 -> open the world map.
But you can change the way the map looks.
196.642 -> Let me delete all the data from this
excel file,
200.241 -> and copy my data of the India and Indian
languages
204.002 -> in here. But this chart does not look so
colorful.
211.202 -> Let me add a third column in the excel
with just 1 to 36 serial number.
218.162 -> Next right click on the map and click on
Select Data. Modify the chart data range
224.881 -> as per your data in the excel sheet. For
me,
228.401 -> the range is from A1 to C36.
Click ok, and there, you have a beautiful
234.722 -> Indian map,
colored as per first official language
238.081 -> of the states.
Now right-click on the map and select
242.882 -> Format Data Series in the map labels. Select
246.722 -> Show All, to see the names of the states.
Next right-click on the map again and
252.802 -> this time,
choose Add Data Labels and the chart
256.562 -> will show the languages,
that are spoken on these states. Let me
261.282 -> add a blank slide.
Go to insert and chart and select Map.
266.641 -> Now in this chart, let me copy the
Goodness Index of the countries
271.122 -> data. Again right-click on the map
and modify the Chart Data Range A1 to
277.962 -> B154. Click ok,
to have all the countries color
282.282 -> populated. You can now close the excel
data file.
286.641 -> Right-click on the map and go-ahead to
the format data series.
291.361 -> Bring in map labels, and play with series
colors.
295.042 -> In the map projection select Mercator,
and there is a huge distortion
300.002 -> in the size of countries. Automatic is
a better solution for this map.
305.361 -> Let me show you another option of adding
307.952 -> a map of a smaller area.
309.442 -> In PowerPoint, this option is best, if you
want to point to a particular location
315.042 -> in a country. Click on insert and click
on Get Add-ins.
319.762 -> In Office Add-ins, Store, search for map
application.
323.921 -> Select the OfficeMaps, and click Add. I
have already downloaded
328.641 -> and added this application in My Add-ins.
Click on the Open OfficeMaps. Click on
335.442 -> Get Started, if you are using it for the
first time. Next,
340.002 -> enter a location in the search bar and
select the option you want.
344.562 -> Let me choose Mumbai. Next click on
settings,
348.802 -> select map size as 16:9 (landscape),
select marker size and color, Include
355.361 -> Address Information,
ON, and then click on Insert Map.
360.962 -> There, you have the location map of
Mumbai
364.002 -> in your PowerPoint slide. I hope you liked
the content of this video. Do check out
370.242 -> my other videos
on this channel. If you want to see more
374.402 -> videos like this,
Subscribe and click on the Bell for all
378.562 -> the notifications.
Please hit like and leave a comment
Source: https://www.youtube.com/watch?v=hUosenD9Muw