XL: Valid Geographic Names for Microsoft Map

Last reviewed: January 9, 1998
Article ID: Q168691
The information in this article applies to:
  • Microsoft Excel 97 for Windows
  • Microsoft Excel for Windows 95, version 7.0

SUMMARY

In Microsoft Excel, you can use Microsoft Map (Microsoft Data Map in Microsoft Excel 7.0) to graphically represent data associated with a geographic area. In order for Microsoft Map to recognize a territory, such as a country or province, the name must be a valid name or abbreviation.

To see a listing of valid geographic territories that Microsoft Map recognizes, open the file, Mapstats.xls. This file is installed with the Microsoft Map program and is located in the folder, C:\Program Files\Common Files\Data Map\Data.

Mapstats.xls contains the following geographic and demographic information:

  • World demographic data by country
  • United States demographic data by state
  • Canada demographic data by province
  • Mexico demographic data by state
  • Europe demographic data by country
  • United Kingdom & Republic of Ireland by county
  • Australia demographic data by state
  • South Africa and neighboring countries by region

For additional information on creating a data map using Microsoft Map, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q147637
   TITLE     : XL: How to Create a Map with Microsoft Data Map


Additional query words: 97 XL97 datamap
Keywords : xlmap
Version : WINDOWS:7.0,97
Platform : WINDOWS
Hardware : x86
Issue type : kbinfo


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: January 9, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.