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

We are using MapPoint 2001 but hope you can still ....

This is a discussion on We are using MapPoint 2001 but hope you can still .... within the MapPoint Desktop Discussion forums, part of the Map Forums category; We are using MapPoint 2001 but hope you can still help. We have an Excel spreadsheet which lists hospitals that ...

  1. #1
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    We are using MapPoint 2001 but hope you can still help.



    We have an Excel spreadsheet which lists hospitals that use and don't use our products (single column with a yes or no for use or don't use). As a hospital starts to use our products, we want to change the column entry from
    a no to a yes and want to automatically "refresh" the map to change the color of a pushpin from a "no" color to a "yes" color. Often there are several hospitals in each city, so pushpins seem to be the best representation. We realize we can accomplish the desired end result by filtering the Excel Worksheet, creating two separate worksheets for
    hospitals that use and don't our products each time after modifying the info, then importing each with a different color pushpin and recreating a new map each time we do updates. It seems that there should be more of an automated way to do this, perhaps by somehow using the "data ranges" which
    quite frankly I don't understand. I would be very grateful for your help.


    Thank you!

  2. #2
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    In the 2002 version of MapPoint, there is a "multiple pushpin" option that allows you to designate an icon for each value in your source file. So in your case, you would select one icon for all YES values, and another for all NO values. You link to the source file (rather than import it), so that changes in the source file are immediately reflected in the map.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hope it can export pushpin points with Lat.&Long
    By Anonymous in forum Wish List
    Replies: 2
    Last Post: 09-30-2004, 04:33 PM
  2. Displaying Mappoint 2001
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 04-03-2003, 02:45 AM
  3. I hope this one is easy
    By cenwesi in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 12-04-2002, 06:37 PM
  4. I am currently running Mappoint 2001 and will buy ....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 09-19-2001, 08:49 AM
  5. Actually, my question is regarding MapPoint 2001 w....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 11-06-2000, 08:46 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