|
Roger,
I thought I would list the steps in case others reading this thread that have never tried this would be able to recreate the steps.
I think this is what you are trying to do?? I could be wrong.
I created a excel file. One column called ZIP and one called Data
I inserted 2 rows consisting of 2 different zip codes. For the data I put 1 in the first row and 2 in the second row.
////////////////////
ZIP Data
21061 1
21144 2
///////////////////
Start the Data Mapping Wizard
Choose Shaded Area
Click Next
Select Import Data To Map It
Click Next
(Brings up the open file dialog)
Choose you excel file
Choose sheet 1
click next
The next screen has allot of info but make sure the column headings show ZIP and Data. Data type "ZIP" for the zip column and "other data" for the Data
There is also an information icon with text that reads "Matching records to: Zip code. Country/Region: United States
Click Next
There should only be one choice in the "Select the data field or column to map (it will be "data")
Show the data by: should be ZIP Code
Click Next
I did not change anything on this screen but the number of ranges is 2
click finish
Mappoint will zoom in to the 2 zip codes. 21061 will be shaded white and 21144 will be shaded green.
Hope this helps |