View Single Post
  #2   Report Post  
bj
 
Posts: n/a
Default

in Excel Hmmm!
pick a map you like Preferably with straight latatude lines
format a XY chart such that the latatude and longitude for the area of
interest will
be covering he area of the map. paste the picture of the map as a background
for the graph and recheck the limits of he X and Y axis so that they the
graph is properly lined up.
make a lookup table with the Cities you are interseted in which they will be
listed by latitude and longitude
Plot the points of interest.
"Michel Girard" wrote:

I have a set of sales data by city, state and zip code. I am looking to map
this data - literally on a map so I can visually see, geographically based,
where sales is going.

Does anybody know of a way to do this?

Thanks
michel