Home |
Search |
Today's Posts |
#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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking the data from one excel to another | Excel Discussion (Misc queries) | |||
Importing xml Data into Excel 2002 | Excel Discussion (Misc queries) | |||
Fan charts | Charts and Charting in Excel | |||
Fetching External Data from Excel | Excel Discussion (Misc queries) | |||
How do I plot data in Excel that is captured on separate sheets; . | Excel Discussion (Misc queries) |