search
Twitter Rss Feeds
MicrosoftArticlesForumsGroups
C# .NET
VB.NET
Visual Studio .NET
ADO.NET
Xml/Xslt
VB 6.0
.NET CF
GDI+
LINQ
Deployment
Security
FoxPro
Silverlight / WPF
Entity Framework
RIA Services

Web ProgrammingArticlesForumsGroups
JavaScript
ASP
ASP.NET
Web Services

Non-MicrosoftArticlesForumsGroups
NHibernate
Perl
PHP
Ruby
Java
Linux / Unix
Apple
Open Source

DatabasesArticlesForumsGroups
SQL Server
Access
Oracle
MySQL
Other Databases

OfficeArticlesForumsGroups
Microsoft Excel
Microsoft Word
Microsoft Powerpoint
Publisher
Money

Operating SystemsArticlesForumsGroups
Windows 7
Windows Server
Windows Vista
Windows XP
Windows Update
MAC
Linux / UNIX

Server PlatformsArticlesForumsGroups
Share Point
BizTalk
Site Server
Exhange Server
IIS
Transaction Server

Graphic DesignArticlesForumsGroups
Macromedia Flash
Adobe PhotoShop
Microsoft Expression

OtherArticlesForumsGroups
Subversion / CVS
Ask Dr. Dotnetsky
Active Directory
Networking
Uninstall Virus
Job Openings
Reviews
Search Engines
Resumes

 

Previous Thread:   How do I prevent users to delete a worksheet, but allow to edit?

9/1/2005 12:10:06 PM    EXCEL 2003 USA Map
In older versions of Excel, I could generate a map of the US as a chart  
  
function.  Specifically to display sales dollars by state.  I cannot find  
  
that functionality in 2003.  Is it still there?

9/1/2005 3:17:49 PM    Re: EXCEL 2003 USA Map
Ivan,  
  
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  
  
"Ivan Hartle" <Ivan Hartle@discussions.microsoft.com> wrote in message  
  
news:88C6674D-3C27-4F5A-950F-094EFC1D346F@microsoft.com...

9/2/2005 9:04:38 AM    Re: EXCEL 2003 USA Map
And if you want a free mapping technique for Excel, try  
  
Map Charts beta - USA at http://edferrero.m6.net/charting.aspx  
  
Not the same functionality as MapPoint, but it might suit you.  
  
Ed Ferrero  
  
http://edferrero.m6.net/


Pete's Blog   |    Pete's Resume   |    Robbe's Blog   |    Robbe's Resume   |    Archive #2   |    Archive #3   |    Dotnetslackers   |    XmlPitStop   |    Advertise   |   Contact Us   |   Privacy   |   Copyright (c) 2000 - 2009 eggheadcafe.com  All rights reserved.