8 hours 33 minutes
Okay, um, in this module,
I'm going to talk to you how to use map charts and excel.
Now, there are no
our points lies. You are going to look, we're just going to go directly to examples,
and there is not much of them. But essentially, the map chart in excel
allows you to
joined geographical data with numbers or geographical locations, been numbers.
And for United States,
you can go down to the level off county zip code etcetera.
for worldwide situation, you're limited just to the country level. So we have here some country levels of this is some mock up data
off sales annual sales from the countries I have bean working with
ah in the past and we want to create the map chart. So we go to insert,
and here we have the option called bing maps. So you click there,
you get Ah,
the location you're in. You don't want that. Do you want a toe pin?
Basically, to show the locations that you have selected here. And you have to be very careful, because if you something type something wrong here,
bing maps won't be able to connect your data with
uh, with geographical location. So, for example, if you if you type the name of the country in local language, it won't work to have to be in English, you can expand the map, you can zoom, and this map is interactive. So
if you click here,
you get cousin Stan. You get sales
and you can close this.
You can also use filters. So, for example, we just won
and, uh, sorry, I didn't say apply.
And now I get this region zoomed.
And when I click here, get Slovenia. When I click here, I get Slovenia. This is this is something that
is slightly an issue. So you have to zoom a little bit and then it picks the right one.
So when I took here, get Serbia.
The problem is that, for example, here with like countries like Croatia,
so Croatia is this year
for you. They don't know it,
and it will pick
geometrical center off the country, which sometimes can be on the border with the other country of the country's shapes.
Unusual, like Croatia is. So, uh, so that's it.
I could add more countries here. I could, uh, put Bosnia Herzegovina which is in the region here on the filter as well. Sorry, you have to do the apply every time. So you click here, you see, you get it slightly
different than it should be. But if you zoom enough
and click here, it will pick the right one. So here it will be Croatia and so on and so on. And this is interactive. So you can leave it together with your data. Or you can put it in
somewhere else like
And you can have it just
on this sheet on this worksheet. So nothing else except this maps. It's very nice representing
sometimes won't do some things,
but here it is. So we do the filter years, we select all the apply
and now we get
something else and we can no
zoom in. We can scroll.
And so So this is example. It has very little data, but you have it for all the countries or
for some cities as well.
Um, it will work nicely. What is also important is that you can at this point, have just one level of data her
a row, so you cannot have more than that.
So let's raise this one because we have it on the other sheet.
S o You just call this, for example, too?
And let's now add another sheet and we'll call it
map and I'll explain Thio
very soon. How do we get it? So we have the same data and weekly country the map
and we have this one. So it's this one
and I have already prepared it a little.
And you have here a list. The fields. It can be more than just the one. So it can be sales and it could be something else. Number of units, for example.
And ah, then ah,
you see way have this region So the highlighted country's air those in the region, the rest is not visible.
You can change the way it's displayed. So, for example, it can be three d bar sticking out of the country. You have here the layer to which you can Sorry, which you can rename and call it.
No sales data.
Get it here.
You can do it like this is Well, that looks pretty much the same.
And, uh, yeah, you can do it with the bubble, which is nice.
Ah, and, uh
and this is it. And now you can do the capture screen.
And if you
switch back to excel
and go to three D map and press paste,
you go that three d map, you can resize it,
but it's not interactive anymore,
but it's useful
if you want to present something and show some geographical stuff. So this is, uh, this is working very nice. Ah, and, uh,
this is how it's done. What you also can do with three D maps
is that you can play tour
on. You can create video
off it. So you removed this, you remove this
and then you say play tour
and whatever you did, it will be recorded here. So if you have
you go back
and you can create video which we are not going to do now. But you see how it looks and you can have multiple scenes. You can have teams.
You can pretty much customize this if you have geographically based data.
one thing that you have to remember is that
bing maps can be confused.
with multiple entries with same name. So, for example, if you're having two towns that are called the same, So, for example, I'm living in a town called Belgrade
and drop, I think, three or four Belgrade's in the United States. So if you're having worldwide data per cities, it can create a mess, and
you won't be able to do things automatically. However, these maps can really help in your presentations and really help with the visualize ing your late, especially its of kinds of sales data or some population data. You can put it on a map easily,
and that's pretty much it regarding this model. I won't be having a recap here because it's Ah, it's a very short story. It's a very simple thing. Along goal. Other map.
The Charts and Maps charts in Excel This son is relatively new. It has
being available since XL 2016
and it will probably improve in the future. But so far this is it. And thank you for your time
Data Analyst Excel
The Data Analyst Excel Test is a premium Cybrary assessment created by iMocha and intended ...
Monitor a Web App
In this IT Pro challenge, participants get hands-on experience activating server logging and using Application ...
Learn On Demand