To limit the states or countries that Microsoft Map displays, follow these steps:
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.
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
Select the map. On the Edit menu, point to Microsoft Map Object, and then click Edit.
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.
On the Map menu, click Features to display the Map Features dialog box.
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.
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.