How can I plot Excel data on a geographical map or chart?

G

Guest

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.
 
T

Tushar Mehta

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
 
E

Ed Ferrero

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Map Style Chart Type 2
Chart Data to a US map 1
How do you plot data points on a state map? 1
Scatter PLotting using Data in third colum to determine range 2
Looking for a U.S. map you can click on state for sales figure? 4
Geographic Mapping 2
Mixing scatter plot with a category plot 2
Surpressing plot of blank cells 3

Top