Microsoft KB Archive/168691

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 11:30, 21 July 2020 by X010 (talk | contribs) (Text replacement - "&" to "&")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Knowledge Base

Valid Geographic Names for Microsoft Map

Article ID: 168691

Article Last Modified on 8/17/2005


  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 95 Standard Edition

This article was previously published under Q168691


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 following 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:

147637 XL: How to Create a Map with Microsoft Data Map

Additional query words: 97 XL97 datamap XL

Keywords: kbinfo KB168691