Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
bamat
 
Posts: n/a
Default How do I create a Map with an Excel worksheet?

I do not have the map toolbar. I tried to customize the toolbar and map is
not on the commands. I am running office ex pro. Can anyone tell me which
program will have it. I am a new excel student.
  #2   Report Post  
Paul B
 
Posts: n/a
Default

bamat, here is a post by Gord Dibben on the subject
Not available with versions 2002 and 2003.

MS Map Point is now the application used.

Costs about $250.00 US.

An alternate is to use MapInfo product(which was the Excel 97 and 2000
product).

Very costly at minimum $595.00 US just for upgrade.

http://www.mapinfo.com/location/integration

But............found this tidbit on the net thanks to Debra Dalgleish.

Mystery of the Missing Map Tool: If you believe Microsoft, the Excel Map
tool
is permanently out of action in Office XP; it's been replaced by the $249
mapping and data analysis package MapPoint 2002. Microsoft assures you that
you can still open and view Excel 97 and 2000 files that contain maps in
Excel
2002, but you can't alter them or create new ones.

Well, I don't always believe what Microsoft tells me. In fact, I've got the
Map tool working pretty well from inside Excel 2002. To be sure, my PC still
has Excel 2000 installed as well, but this trick might be worth a try even
if
you don't, as long as you still have your Office 2000 CD-ROM and don't fancy
shelling out the cash for MapPoint: Using Excel 2002, open an Excel 2000
file
with a map in it and double-click the map. If you're prompted to, place your
Office 2000 disc in the drive so it installs the Map tool; the application
will then load and you can alter the map from within XP.

You can also create new maps in Excel 2002 using Insert / Object / the
Create
New tab / Microsoft Map and clicking OK. Choose the country, then, when the
map is created, choose Insert / Data to select the data for the map. It
isn't
as easy as it used to be, but it does work.
The site Debra referred to was...

http://www.winplanet.com/article/1818-.htm
Gord Dibben Excel MVP


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"bamat" wrote in message
...
I do not have the map toolbar. I tried to customize the toolbar and map

is
not on the commands. I am running office ex pro. Can anyone tell me which
program will have it. I am a new excel student.



  #3   Report Post  
roblo
 
Posts: n/a
Default


In office 2003 you can use this link:

http://tinyurl.com/dddel


--
roblo
------------------------------------------------------------------------
roblo's Profile: http://www.excelforum.com/member.php...o&userid=22469
View this thread: http://www.excelforum.com/showthread...hreadid=378259

  #4   Report Post  
Bryan Gray
 
Posts: n/a
Default

I found this mapping software a while ago. Let me know what you think.
http://cbdusa.com/TheTown/default.htm
They even have a video of the software in action!


"bamat" wrote:

I do not have the map toolbar. I tried to customize the toolbar and map is
not on the commands. I am running office ex pro. Can anyone tell me which
program will have it. I am a new excel student.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging data from an excel worksheet into an excel template pkasler Excel Worksheet Functions 1 March 13th 05 04:36 AM
i need to create an invioce in EXCEL and then send it into a WORD. cassie Excel Discussion (Misc queries) 1 March 12th 05 07:49 PM
Hyperlink to specific worksheet in Excel Glenn Mulno Links and Linking in Excel 2 February 7th 05 06:01 PM
How do I replace a worksheet with another worksheet in excel Ammnon Excel Worksheet Functions 1 January 12th 05 10:48 AM
Need to remove a password that noone placed on Excel worksheet. tuffy1104 Excel Worksheet Functions 2 January 2nd 05 07:12 PM


All times are GMT +1. The time now is 04:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"