Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Graphs
I am trying to figure out if and how one can display sales data in a Excel
graph where the data is presented in a geograpical map of North America. For example, i want to display sales numbers by city and province / state in / on / over a map or atlas image? Can anyone offer advise as to how one can do this? Thanks Mark |
#2
|
|||
|
|||
Mark,
I don't think Excel can do that type of thing. We historically had to this type of thing by hand in powerpoint over a clipart map. Last summer, we bought MS MapPoint 2004 to do cool map charts. I didn't end up getting it but my collegue did and he found it fairly easy to use. His final map charts showed sales information right on top of a city/state/area and he could divide the map into our company regions. He could also plot out the competitions locations (down to the street) against ours as well as some of our major customers to create density/sales/opportunity maps. (VERY COOL) c. "Mark" wrote: I am trying to figure out if and how one can display sales data in a Excel graph where the data is presented in a geograpical map of North America. For example, i want to display sales numbers by city and province / state in / on / over a map or atlas image? Can anyone offer advise as to how one can do this? Thanks Mark |
#3
|
|||
|
|||
Thanks for your assistance Christine. I'll look into the MapPoint Program.
Thanks Mark "Christine" wrote: Mark, I don't think Excel can do that type of thing. We historically had to this type of thing by hand in powerpoint over a clipart map. Last summer, we bought MS MapPoint 2004 to do cool map charts. I didn't end up getting it but my collegue did and he found it fairly easy to use. His final map charts showed sales information right on top of a city/state/area and he could divide the map into our company regions. He could also plot out the competitions locations (down to the street) against ours as well as some of our major customers to create density/sales/opportunity maps. (VERY COOL) c. "Mark" wrote: I am trying to figure out if and how one can display sales data in a Excel graph where the data is presented in a geograpical map of North America. For example, i want to display sales numbers by city and province / state in / on / over a map or atlas image? Can anyone offer advise as to how one can do this? Thanks Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
graphs showing unwanted zero values | Excel Discussion (Misc queries) | |||
Automate Excel to powerpoint - Graphs along with Datasheet (not workbook) | Charts and Charting in Excel | |||
2 graphs on 1 single chart cheet | Charts and Charting in Excel | |||
Line Graphs and Bar Graphs | Excel Discussion (Misc queries) | |||
Graphs and sheet referencing? | Excel Worksheet Functions |