8 hours 33 minutes
in this module, I'm going to trying to explain to you how to work with map charts and maps charts. Here's relatively new thing in Excel. Its uses bing maps that are available on Internet
and can connect data from Excel to the big maps.
This is going to be relatively short module. Just one lesson, and let's skip with the introduction
and just go to the example how the map charts are used.
um, in this Excel sheet, we have, ah, sales data half her country. So this is nothing special. Nothing in detail. We just have country listed, and we have the numbers that represents sales in millions of dollars
we can select these
countries. We can just click on the insert tab. And then there is a big maps
and you get the simple map, which gives you your location, which is in this case, my location, which is Belgrade.
And then you click on show locations
and then you get the wider view. You can resize this map.
You can zoom in so you get just the region you want,
and it's there
and their countries, and
so it gives you
the information off what do you have there?
So if we click on this
put in the shipping as well,
we'll get the sails and millions of dollars on pavement so Excel will recognize this is a heather of the table or heading and included there. So if you click here, we get nothing. If you get in, Kazakhstan
begins much bigger sales because this is much bigger market
and so on and so on. And we can expend this map a little bit further. We want
eso like this'll ce
No, this is pretty much as far as it goes. We can still zoom in a little
and then we can look att, the data for individual countries.
So especially here in
welcome area where they're very close.
So you see, it's saying Slovenia and this is not Slovenia. So I actually have to zoom in a little
to get specific data or let's close this. Yeah, you see, we have to zoom in a little bit more. So this is slightly to the imprecision off being maps. So this is giving me data for Croatia, which is here,
and I want data for Serbia and they get data for Bosnia Herzegovina and let zoom a little bit more.
And now I'm getting late for Serbia. So this is how it works.
There's also one thing that you should notice is that
you see this area here
weirdly shaped area is Croatia.
And what is Ah, being maps doing is putting this area in a rectangle that fits snugly to the area you're looking at. And then it puts your data your your circle
at the center of that rectangle.
So what happens is that because Croatia is like this,
the data for Croatia is not set the somewhere where the capital is, which should be here.
I know it's here. Where is it
use? You see the geometric center off the region that Croatia is occupying. So this is how it works.
It's slightly imprecise, but you have to take care off
zooming in all the time. If you want to get this data also, you see the size off the circles represent the size off sales. So here we go here, you see that the largest sales is in Kazakhstan and it's the biggest circle. So this is
this is how it works.
the level of detail you can go is the other story. So, for example, let's say that we want to split Europe in four parts and we say Western
And then we say northern
And then we see
and then received
And then we put some numbers here. It doesn't matter. So 78 65
56 44 then we select these
and we just want to pin them there
and we get something that we didn't expect.
Eastern Europe, Ukraine. You get this number for all of Eastern Europe
because Ukraine, in being databases, has the designation that is in Eastern Europe.
But here we get just Europe and we actually actually got the numbers for Western Europe,
not precise. So if you click here,
we get data for Southern Europe here, so it doesn't work.
But for example, if this would be Iberia,
then suddenly it works because Iberian peninsula
And if you click, Iberia bingo or Excel will connect this to the geographic term called Iberian Peninsula, and then this will work. Also, if he instead of Southern Europe or Eastern Europe, for example, we put here Balkans.
It will work because Balkans, Let's close this
because North Macedonia, the country of north Macedonia, is said to be in Balkans and it will set it here, which is pretty much correct because this region here is concerned to be Balkans. So
it kind of works. Ah, so you have to be really careful that you put in this
data that actually exists in big maps out
you can go to the 7 11 look detail, but what you can't do
is, for example, if you want some other data as well.
So if we copy this and being this,
we can do this. But if we want, for example, too,
put some cities within each country. So we have to,
major eso, for example, this can be
profit or whatever.
it cannot be because it's bigger than sales. But just for the
let's say this is one, and this is I don't know, 1.1 and sorry
and 1.1 in here rips but
and here we have I don't know
And then you get all of these numbers so you get both the blue and the red circles or red circles for profit.
Blue circle is for sales. So revenue. Um,
but if we want to put here
another Kahlan and say, for example,
uh, city off, Your Honor, which is capital of Slovenia,
and then we select these. So we say city,
and then we select all of this
and pin it. We get the message that it is. The data is in. Really? Because you cannot
to description columns, you can put more. Number comes, but you can't put two description codes so it doesn't work.
And we're going to continue about the story about details in the next video where we will continue this lesson.
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