You are currently offline, waiting for your internet to reconnect

MapPoint: How to Create Shaded Area Maps

This article was previously published under Q239419
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
SUMMARY
This article describes how to use Microsoft MapPoint with Microsoft Excelto create shaded area maps based on boundries such as counties, states, orZIP codes.
MORE INFORMATION
To create a shaded area map based on counties, states, or ZIP codes:

  1. Start Microsoft Excel.
  2. Create a workbook with the following column labels based on the type of map you want to create:

    Map typeCountyStateZIP codeShading value
    StateNoYesNoYes
    CountyYesYesNoYes
    ZIP codeNoNoYesYes

    NOTE: Type your data according to the following guidelines.

    • State: Type the full State name or official two-letter abbreviation.
    • County: Type the full county name
    • ZIP code: Type the five-digit ZIP code.
    • Shade: Type a shade value from 1 (lightest) to 8 (darkest).
    For example, if you want to create a County map type, add your data to the workbook using the following table format:
    CountyStateShading value
    KingWa1
    SnohomishWa2
    PierceWa3
    KitsapWa4
    MasonWa5
    ThurstonWa6
    NOTE: King, Kitsap, Mason, Pierce, Snohomish, and Thurston are the names of counties in Washington State and "Wa" is the abbreviation for Washington.

  3. On the File menu, click Exit. When you are prompted to save the changes, click Yes.
  4. Start MapPoint.
  5. On the Format menu, click Data Mapping Wizard.
  6. Click Shaded Area Map, and then click Next.
  7. Click Import, and then click the Excel file that you saved in Step 3.
  8. If necessary, click the worksheet that contains your data.
  9. In the Data Import Wizard window, verify that the data appears as you expect, and then click Next.
  10. Click Finish.

    NOTE: If you want to customize the appearance of your map, clickNext.
mp2000 mp2001 multi multi-media media mm coloring colors
Properties

Article ID: 239419 - Last Review: 01/25/2007 01:16:40 - Revision: 2.1

  • Microsoft MapPoint 2000 Standard Edition
  • Microsoft MapPoint 2001 Standard Edition
  • kbhowto kbinterop kbui KB239419
Feedback