Can Excel use addresses to create points on a Map?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nate - 26 Sep 2007 23:46 GMT

I am trying to create a Graph from a bunch of addresses and have them show up
on a map of California/U.S.A. I was wondering if anyone has done that and
can help me.

Reply to this Message

ShaneDevenshire - 27 Sep 2007 06:29 GMT

Hi,

Excel does not have such a feature.

Signature

Sorry,
Shane Devenshire

> I am trying to create a Graph from a bunch of addresses and have them show up
> on a map of California/U.S.A. I was wondering if anyone has done that and
> can help me.

Reply to this Message

Del Cotter - 27 Sep 2007 08:07 GMT

>Excel does not have such a feature.

Sure it does. XY (Scatter) Chart, using a map of the area as a picture
Background. Set the axis scale maxima and minima to match the
background's known corners, and plot the locations as points.

Signature

Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.

Reply to this Message

ShaneDevenshire - 28 Sep 2007 05:51 GMT

Excel had this feature in the 1997 version, a mapping feature which it
removed from the program. You can fake it but nevertheless, this feature has
been removed and is no longer included.

Signature

Cheers,
Shane Devenshire

> >Excel does not have such a feature.
>
> Sure it does. XY (Scatter) Chart, using a map of the area as a picture
> Background. Set the axis scale maxima and minima to match the
> background's known corners, and plot the locations as points.

Reply to this Message

Del Cotter - 28 Sep 2007 08:37 GMT

>Excel had this feature in the 1997 version, a mapping feature which it
>removed from the program. You can fake it but nevertheless, this feature has
>been removed and is no longer included.

I'm not referring to the Microsoft Map thematic mapping feature, that
was removed after (I think) MS developed it as a separate application
called MapPoint. I'm talking about a scatter graph on a picture.

(I've also done it with bubble graphs, but that's less convenient as
there is no easy way to make the bubble radius scale properly)

Are you saying that Excel no longer supports the use of pictures as
backgrounds to the plot area?

Signature

Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.

Reply to this Message

David Biddulph - 28 Sep 2007 12:27 GMT

Pictures as backgrounds till there in Excel 2003.

Signature

David Biddulph

>>Excel had this feature in the 1997 version, a mapping feature which it
>>removed from the program. You can fake it but nevertheless, this feature
>>has
>>been removed and is no longer included.

> I'm not referring to the Microsoft Map thematic mapping feature, that was
> removed after (I think) MS developed it as a separate application called
> MapPoint. I'm talking about a scatter graph on a picture.

...

> Are you saying that Excel no longer supports the use of pictures as
> backgrounds to the plot area?

Reply to this Message

Kelly O'Day - 27 Sep 2007 15:49 GMT

Nate:

You can export your Excel based addresses to GoogleEarth or GoogleMap and
produce a professional looking map.

JuiceAnalytics has a very nice Excel workbook that provides tools to get the
latitudes and longitudes of your addresses, create a Keyhole Markup Language
(KML) file (KML is map version of XML), then open GoogleEarth and display
your addresses in GoogleEarth.

Here's the link to Juice's free workbook.

http://www.juiceanalytics.com/writing/2006/04/excel-geocoding-tool-v2/

You'll need access to a geocode service. I use Yahoo's. It's free, you just
need to have a User ID.

Also, you'll need to have GoogleEarth or GoogleMap on your PC. Also free.

With GoogleEarth of GoogleMap you can make custom maps by turning map
features on/off, and adjusting zoom level. If needed, you can copy/paste
your GoogleEarth map back into Excel or include a link to the real map.

The marriage of Excel for data handling and GoogleEarth/Map for map display
makes a lot of sense. Why try to digitize a crude map in Excel when you can
use a powerful tool like GoogleEarth for your maps?

Kelly O'Day

http://processtrends.com

>I am trying to create a Graph from a bunch of addresses and have them show
>up
> on a map of California/U.S.A. I was wondering if anyone has done that and
> can help me.

Reply to this Message