Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 3 of 3

Newbie help; using Excel data to map by COUNT

This is a discussion on Newbie help; using Excel data to map by COUNT within the MapPoint Desktop Discussion forums, part of the Map Forums category; I have an Excel file with data on 200 customers. The only geographic data I have is 5 digit ZIP ...

  1. #1
    rjhbos is offline Junior Member White Belt
    Join Date
    Jul 2004
    Posts
    2

    Newbie help; using Excel data to map by COUNT

    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.

  2. #2
    jdwhytie is offline Member Yellow Belt
    Join Date
    Jun 2004
    Posts
    37
    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

  3. #3
    rjhbos is offline Junior Member White Belt
    Join Date
    Jul 2004
    Posts
    2
    Quote Originally Posted by jdwhytie
    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!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Newbie- Converting Mappoint 2004 data to Map Info data
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 5
    Last Post: 06-10-2004, 02:11 PM
  2. Newbie Question - Importing XLS data
    By Messier in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 02-09-2004, 08:17 AM
  3. Exporting data to Excel
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 08-28-2002, 03:57 PM
  4. I am plotting data by zip codes for Seminole Count....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-09-2002, 07:20 AM
  5. How do I map county data? Do I put state and count....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 07-08-1999, 07:16 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96