If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can I plot Excel data on a geographical map or chart?
I have data by city, state, and zip code. How can I plot this data by
geography on a map of the United States of America or on a map of a state. |
#2
|
|||
|
|||
Some version of XL had that some rudimentary capability in that area.
However, MS stripped it out and together with other goodies created a separately priced product called, I believe, MS MapPoint. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I have data by city, state, and zip code. How can I plot this data by geography on a map of the United States of America or on a map of a state. |
#3
|
|||
|
|||
Hi dasage,
There is a sample workbook on my charting page at http://edferrero.m6.net/charting.aspx that will do what you want. The workbooks on my site are intended for demonstration and teaching purposes, they are not full applications with error trapping and nice user interface. Still, this should get you started. Look for Map Charts beta - USA. Ed Ferrero http://edferrero.m6.net I have data by city, state, and zip code. How can I plot this data by geography on a map of the United States of America or on a map of a state. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I import formmail data to a custom excel template? | cxlough41 | Worksheet Functions | 1 | July 1st, 2005 12:59 AM |
Word Field Codes in Excel data file | mranz | Mailmerge | 7 | December 11th, 2004 09:02 AM |
Merge data from Excel into different docs in one Word file | sue_w1231 | Mailmerge | 1 | November 16th, 2004 12:55 AM |
Is this possible with Excel Chart? | q582gmzhi | Charts and Charting | 1 | September 8th, 2004 03:33 AM |
Word mail merge with Excel data | Peter Jamieson | Mailmerge | 1 | April 26th, 2004 07:30 PM |