HOW TO: Use Microsoft Map to Display Specific States and Nations in Excel 2000

In Microsoft Excel 2000, you can use Microsoft Map to limit the states or countries shown on a map to a given list. By default, Microsoft Map includes all the states or countries when it draws a map.

Display Specific States and Nations

To limit the states or countries that Microsoft Map displays, follow these steps:

1. Create a data map, and then select the area of map to be shown.
   
   For example, for a map of the United States, display the toolbar that contains the Map button, click Map, and then use the pointer to draw a map box. In the Unable to Create Map dialog box, double-click United States (AK & HI Inset), and then click OK.
2. Create a column of geographic data that uses the state or country names that you want, or use their standard abbreviations.
   
   For this example, type the following:

      A1: WA
      A2: ID
      A3: CA
   					

3. Select the map. On the Edit menu, point to Microsoft Map Object, and then click Edit.
4. On the Insert menu, click Data. Highlight the range of data on the worksheet that contains the states or countries that you want to show. In this example, select A1:A3.
   
   The corresponding states are shaded gray on the map.
5. On the Map menu, click Features to display the Map Features dialog box.
6. Click to clear the Visible check box for the map that you are using, and then click OK. In this example, click United States (AK & HI Inset)

All non-shaded states and unused boundaries disappear.

How to Change the Default Shading Options

The default shading color for a state or country is based on a count of the number of entries for each state or country name. To change the color, follow these steps:

1. If the Microsoft Map Control window is not visible, click Microsoft Map Control on the View menu.
2. On the Map menu, click Value Shading Options.
3. In the Format Properties dialog box, select the color that you want in the Color list.
4. To make all states the same color, change the number in the Number of value ranges box to 1, and then click OK.

For more information about Microsoft Map, click Microsoft Excel Help on the Help menu, type get more help about maps in the Office Assistant or the Answer Wizard, and then click Search to view the topic.