Creating maps and inserting in worksheets

[S Zero]

I was just curious if there is anything out there for Mac that would allow
you to build maps and insert them into worksheets (like the old MS Map
feature for Excel in Windows which became MapPoint)? I'd like to take some
data in pivot tables and turn it into maps and was curious if it's possible?
Or is this another case like MS Access not being available for us Mac users?


Any recommendations would be greatly appreciated.

 

[Geoff Lilley]

Others may have a suggestion, but my research shows there is no such
software at this time. Your best bet would be if you have PivotTable
data, to group it by some appropriate commonality, like "region." In
other words, you could have double or triple row fields:
1) The outermost row field could be something like "Region" (Pacific
Northwest would include California, Washington, Oregon, Nevada,
Arizona, for example; the Eastern Seaboard would be such states as New
Jersey and Massachusetts, for example)
2) The middle row field could be the state itself (listed
alphabetically)
3) Within the state could be either the city or the county, as need
dictates.

Then, the data field would be the data you're trying to aggregate.

I know it's not a perfect solution, but I figured where there's a will,
there's a workaround.

HTH.
Cheers,
Geoff Lilley
Microsoft Office Master Instructor (2000/XP)
Apple Certified HelpDesk Specialist (OS X 10.4)

 

[Geoff Lilley]

Follow up on the maps:
http://support.microsoft.com/kb/274220/en-us?spid=2513&sid=101

Not supported in Office for Mac.

Geoff

 

[S Zero]

Thanks Geoff. That's not a bad solution really because then data can be
output into a chart (type) of my choosing. It might not be the same as
looking at a graphical representation of individual states but it would be
some type of *visual* image nontheless

 

[square_cube]

This isnt exactly what you are looking for as the result is outside of
Excel, but it is a relatively simple way of putting data on maps:

http://www.biovolution.com/imap/

However, at $199 a hit, this is not a cheap solution

cheers

james

 

[cwhaley]

If the goal were ultimately to put your map data on the net, where it's
accessible from any browser, you might also consider another
(third-party) solution... MapBuilder. It's free.

MapBuilder capitalizes on Google Maps (also free) API, and is aspiring
to be a very user-friendly way to map data. (It still has some rough
edges, but the price is right).
It's an example of what are called mashups, because it's mashing
together your data with maps created by Google.

Here's a rudimentary example that I put together for my
Toronto-oriented live music site...

http://TorontoLiveClubHub.com/Clubs/clubs.html

My data are club locations, links to club home pages, links to club
listings, and specific addresses.

I'm using a city-level map, but you can put your data on any map
globally that Google Maps can create.

As you'll see you have a map of your locations.. in your case states or
whatever with a map pin for each. Clicking the pin or the location in
your list brings up an information balloon with as many fields as you
feel are practical to include.

I actually entered the data for my map manually, but that's only
because the IMPORT feature wasn't there at the time. Now, you can
simply upload your Excel data (via an .csv file). I'll be doing that
for all future maps.

For other examples, click on Booming Maps at the mapbuilder.net site.
There's also A Google Group like this one to swap info with others.

.....Charles