Microsoft Map can use either the five-digit ZIP code or the nine-digit ZIP code. This data must be formatted in the five-digit or five-plus-four-digit ZIP code format to be considered valid geographic data. To format a range as valid ZIP code data, follow these steps:
On an Excel worksheet, type the ZIP code data in column form. For example, type the following:
A1: 68820 A2: 68871 A3: 68801
Select the range of the ZIP code data, and then click Cells on the Format menu.
In the Format Cells dialog box, click Special under Category, and then click Zip Code under Type (click Zip Code+4 if you are using the nine-digit ZIP code format).
Microsoft Map can accept only the Forward Sortation Area part of the Canadian postal code as valid geographic data. The Forward Sortation Area consists of the first three characters of the Canadian postal code. For example, for the following Canadian postal codes
E1C 19B V8X 3X4 T2H 1W8
you type data that Microsoft Map uses in an Excel worksheet as follows:
To add postal codes to an existing Microsoft Map, follow these steps:
Type the postal codes in a column, as shown earlier in this section.
Double-click the existing Microsoft Map to activate it.
Double-click the activated map to open the Map Features dialog box. If the postal code feature is missing, click Add, click the name of the postal code feature for the country that you are using, and then click OK.
NOTE: Even after you add the feature to the map, the selection box is unavailable (appears dimmed) and it cannot be selected.
On the Insert menu, click Data, select the range of postal codes that you have created, and then click OK.
NOTE: You can insert only one column of geographical data at a time. ZIP codes and state names are examples of different kinds of geographical data. You cannot combine different kinds of geographic data in a single column.
When Microsoft Map adds the symbols for each postal code center, it addslarge circle symbols, which you can modify. To do so, follow these steps:
Double-click an existing map to activate the map.
On the View menu of the activated map, click Microsoft Map Control.
In the lower-right box of the Microsoft Map Control, double-click the Graduated symbol (the star shape).
In the Format Properties dialog box, click the Graduated Symbol Options tab, and then click Modify Symbol.
Click any symbol that is displayed in the Symbol dialog box.
To change the size or color of the symbol, click Font, change the number in the Size box, and then change the color in the Color box.
NOTE: You can edit the font size so that it is a number smaller than the number that is displayed in the list.
Click OK three times and close Microsoft Map Control.
The shape, size, and color of the graduated symbol used for postal codescannot be changed for individual postal centers. Graduated symbols changeas a group, based on the settings on the Graduated Symbols Options tab.