MapForums

I have an Excel file with data on 200 customers. The only geographic data I have is 5 digit ZIP code. All customers are within a similar geographic region (i.e. not spread out nationwide.)

How do I create a map with graduated shading to indicate those zip codes with more customers?

I need a field to indicate a count of customers per zip code I suppose and I tried this with a pivot table in excel.

I get a table with about 50 zipcodes and the count of customers for each. The problem is when I try to map this data in MapPoint, I am told I have "more than 8 unique data items" and can't map them.

Obviously I am missing something very fundamental.

Thanks for any replies.

It sounds like you are trying to do a shaded area map with discrete ranges, this only allows for 8 different ranges, you could try a continuous range (change the range type in the data mapping wizard), that might get you what you want

Thanks.
My problem was that the column with the count of each zip code was formatted as text. That only allowed displaying data as discrete ranges.

I re-formatted the column as numbers, selected continous range as you suggested and that worked!