Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can Excel use addresses to create points on a Map?
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can Excel use addresses to create points on a Map?
Hi,
Excel does not have such a feature. -- Sorry, Shane Devenshire "Nate" wrote: 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. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can Excel use addresses to create points on a Map?
On Wed, 26 Sep 2007, in microsoft.public.excel.charting,
ShaneDevenshire said: 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. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can Excel use addresses to create points on a Map?
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/writin...oding-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 "Nate" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can Excel use addresses to create points on a Map?
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. -- Cheers, Shane Devenshire "Del Cotter" wrote: On Wed, 26 Sep 2007, in microsoft.public.excel.charting, ShaneDevenshire said: 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. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can Excel use addresses to create points on a Map?
On Thu, 27 Sep 2007, in microsoft.public.excel.charting,
ShaneDevenshire said: 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? -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can Excel use addresses to create points on a Map?
Pictures as backgrounds till there in Excel 2003.
-- David Biddulph "Del Cotter" wrote in message ... On Thu, 27 Sep 2007, in microsoft.public.excel.charting, ShaneDevenshire said: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I CREATE LABELS OR ADDRESSES ON ENVELOPES | Excel Discussion (Misc queries) | |||
How do create a formula to add IP addresses? | Excel Discussion (Misc queries) | |||
create pairs of addresses? | Excel Discussion (Misc queries) | |||
How do I create a list of names and addresses? | Excel Discussion (Misc queries) | |||
HOW DO I CREATE LABELS OR ADDRESSES ON ENVELOPES | Excel Discussion (Misc queries) |