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 4 of 4

How do I display text data by zip code?

This is a discussion on How do I display text data by zip code? within the MapPoint Desktop Discussion forums, part of the Map Forums category; I uploaded my data which includes a column of zip codes and a data field column called "Dollars Spent". I ...

  1. #1
    vtkendra is offline Junior Member White Belt
    Join Date
    Jun 2010
    Posts
    4

    How do I display text data by zip code?

    I uploaded my data which includes a column of zip codes and a data field column called "Dollars Spent". I was able to successfully map the data to show a shaded color based on dollars spent. For example, light green is 0-$50, medium green is $51-$100 and dark green is $100. This is just an example.

    However, I would also like to show the amount in text on top of the shaded zip codes. For example, I would like to show the shaded color and the amount on time such as $13, $56, $107, etc. based on the exact amount for that zip.

    Is there a way to show the actual text value of the data on top of the zip code? I've been searching the help and tutorials but I have not found a way to do it.

    Thanks,
    Kendra

  2. #2
    Mattys Consulting's Avatar
    Mattys Consulting is offline Senior Member Black Belt
    Join Date
    Dec 2002
    Posts
    1,040

    Re: How do I display text data by zip code?

    Hi Kendra,

    Try changing the "Zip Code" column to "Territory"
    Then use the Territory Wizard to create territories of each Zip Code.
    It just might work!
    Michael R Mattys
    Business Process Developers
    www.mattysconsulting.com

  3. #3
    vtkendra is offline Junior Member White Belt
    Join Date
    Jun 2010
    Posts
    4

    Re: How do I display text data by zip code?

    Quote Originally Posted by Mattys Consulting View Post
    Hi Kendra,

    Try changing the "Zip Code" column to "Territory"
    Then use the Territory Wizard to create territories of each Zip Code.
    It just might work!
    Thanks for the idea. I tried uploading the zip codes as territories and it did display the zip code number as text over the zip code area on the map (ex: 20852). However, I could not figure out a way to show the dollar amount associated with that zip code as text over the map. For example, if 20852 generated $50 in expenses, I want the text to say $50 rather than 20852.

    Here's the format of my Excel file:

    Zip Code Dollar Amt
    20852 $50
    20850 $23
    20854 $105
    etc.

    Do you have any other thoughts on how I could achieve this?

    Thanks,
    Kendra

  4. #4
    Mattys Consulting's Avatar
    Mattys Consulting is offline Senior Member Black Belt
    Join Date
    Dec 2002
    Posts
    1,040

    Re: How do I display text data by zip code?

    Kendra, you need to make the "Zip Code" column have the title "Territory",
    then it will work.
    Michael R Mattys
    Business Process Developers
    www.mattysconsulting.com

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Using zip code data, suppressing zip code labels?
    By Santa Monica Realtor in forum MapPoint Desktop Discussion
    Replies: 6
    Last Post: 07-30-2010, 09:50 AM
  2. Display Pushpin Location on Map from Text Input
    By ocinfo in forum Development
    Replies: 2
    Last Post: 03-15-2009, 12:37 PM
  3. Display 3-digit zip code boundaries
    By juilianoj in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 06-17-2008, 01:21 PM
  4. NewbieQ: How do I display text in a territory?
    By mj_stev in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 10-23-2007, 08:41 AM
  5. Import data from a text file
    By Val in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 07-08-2003, 07:15 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