XL2000: Valid Geographic Names for Microsoft Map (214385)



The information in this article applies to:

  • Microsoft Excel 2000

This article was previously published under Q214385

SUMMARY

In Microsoft Excel 2000, you can use Microsoft Map to graphically represent data associated with a geographic area. For Microsoft Map to recognize a territory, such as a country or province, the name must be a valid name or abbreviation.

MORE INFORMATION

If you have installed Microsoft Map, you can see a listing of valid geographic territories that Microsoft Map recognizes by opening the following file:

Mapstats.xls

This file is installed with the Microsoft Map program and is located in the following folder:

C:\Program Files\Common Files\Microsoft Shared\DataMap\Data

Mapstats.xls contains the following geographic and demographic information:
  • World data by country
  • United States data by state
  • Canada data by province
  • Mexico data by state
  • Europe data by country
  • United Kingdom and Republic of Ireland data by county
  • Australia data by state
  • South Africa and neighboring countries data by region

REFERENCES

For additional information about creating a data map using Microsoft Map, click the article number below to view the article in the Microsoft Knowledge Base:

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

For more information about Installing Microsoft Map and creating maps in Excel, click Microsoft Excel Help on the Help menu, type create a map in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

Modification Type:MajorLast Reviewed:11/5/2003
Keywords:kbhowto kbinfo KB214385