Today, in Episode #1335, Lisa Marie asks if you can get Excel data on to a map. In this episode, Bill shows us how to create a Shaded Region Map using Microsoft MapPoint "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Learn Excel from MrExcel podcast, episode 1335.
Map Data.
Hey! Welcome back to the MrExcel netcast.
I'm Bill Jelen.
It's Groundhog's day, February 2nd, 2011.
Today's question sent in by Lisa Marie.
Lisa wants to know, how they just take data from Excel and put that on a map.
I've done this before, let's do it a little bit differently this time.
I'm here in Map Point 2010.
Go to Data, Import Data Wizard we'll use that country data that we created a podcast, two days ago.
And it's really important that you have a heading there.
So, my column heading was country and they guess that means Country-Region.
All right, so kind of give them both a nice little clue there.
All right, so they didn't get Macedonia.
I guess the country name officially is that, at least according to Microsoft.
So accept that one and what we're going to do today is we're going to create a shaded area map.
So, let's click [ next ], we'll take a look at the settings there.
We're going to show the data country or region and the count.
All right, now they're offering us a continuous logarithmic range.
I'm going to change this, I'm going to say, let's go with equal data points and kick that up to about 5.
We'll choose a different color set here.
I'm going to use this one and you know, I look at this, and they're breaking an outside way, there's about 18 in each one.
But it really doesn't make any sense to have a legend of 8 to 114.
Yeah, so let's see, what would happen if we went from 20 on up to 125.
All right, so that gives us about six countries, and then probably what's the next thing that makes sense maybe we go from 10 to 19, that gives us eight countries and then from 5 to 9 in essence and then yeah, 2 to 4 and 1 to1.9.
In other words, just one hit in those particular countries.
We click [ finish ] and let's scroll, first of all we'll get rid of our legend and over you here try and make it a little bit smaller.
So, we did that into the screen.
Yeah, okay! So, there's our map.
It has the countries with the legend, which I just closed on left hand side.
Nice, little view and you can also, if you want to, you can zoom in using the zoom in tools and get a very detailed view of any particular region.
So, just a beautiful way to take data from Excel and put it on a map, in this case we're using a shaded region.
It's also possible to show data based on a larger dot, based on the size or various other things using Microsoft Map Point.
Thanks to Lisa Marie for sending that question.
Thanks to you for stopping by, see you next time for another netcast from MrExcel.
Learn Excel from MrExcel podcast, episode 1335.
Map Data.
Hey! Welcome back to the MrExcel netcast.
I'm Bill Jelen.
It's Groundhog's day, February 2nd, 2011.
Today's question sent in by Lisa Marie.
Lisa wants to know, how they just take data from Excel and put that on a map.
I've done this before, let's do it a little bit differently this time.
I'm here in Map Point 2010.
Go to Data, Import Data Wizard we'll use that country data that we created a podcast, two days ago.
And it's really important that you have a heading there.
So, my column heading was country and they guess that means Country-Region.
All right, so kind of give them both a nice little clue there.
All right, so they didn't get Macedonia.
I guess the country name officially is that, at least according to Microsoft.
So accept that one and what we're going to do today is we're going to create a shaded area map.
So, let's click [ next ], we'll take a look at the settings there.
We're going to show the data country or region and the count.
All right, now they're offering us a continuous logarithmic range.
I'm going to change this, I'm going to say, let's go with equal data points and kick that up to about 5.
We'll choose a different color set here.
I'm going to use this one and you know, I look at this, and they're breaking an outside way, there's about 18 in each one.
But it really doesn't make any sense to have a legend of 8 to 114.
Yeah, so let's see, what would happen if we went from 20 on up to 125.
All right, so that gives us about six countries, and then probably what's the next thing that makes sense maybe we go from 10 to 19, that gives us eight countries and then from 5 to 9 in essence and then yeah, 2 to 4 and 1 to1.9.
In other words, just one hit in those particular countries.
We click [ finish ] and let's scroll, first of all we'll get rid of our legend and over you here try and make it a little bit smaller.
So, we did that into the screen.
Yeah, okay! So, there's our map.
It has the countries with the legend, which I just closed on left hand side.
Nice, little view and you can also, if you want to, you can zoom in using the zoom in tools and get a very detailed view of any particular region.
So, just a beautiful way to take data from Excel and put it on a map, in this case we're using a shaded region.
It's also possible to show data based on a larger dot, based on the size or various other things using Microsoft Map Point.
Thanks to Lisa Marie for sending that question.
Thanks to you for stopping by, see you next time for another netcast from MrExcel.
