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

Pushpin color based on value AND shape based on type

This is a discussion on Pushpin color based on value AND shape based on type within the MapPoint Desktop Discussion forums, part of the Map Forums category; I need to import map data where the color is based on an associated value (no problem there), but the ...

  1. #1
    Roger Allen is offline Junior Member Yellow Belt
    Join Date
    Oct 2010
    Posts
    28

    Pushpin color based on value AND shape based on type

    I need to import map data where the color is based on an associated value (no problem there), but the shape needs to be based on location type.

    e.g.
    Value 1 to 10 = Red
    Value 11 to 20 = Yellow
    Value 21 to 30 = Green

    Type A = Circle
    Type B = Triangle
    Type C = Square

    So a type B point with value 15 would be a yellow triangle

    I would appreciate suggestion on how to go about this.

    Thanks

    Roger

  2. #2
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Re: Pushpin color based on value AND shape based on type

    You would have to "pre-code" your data with the symbol in a single column. Then you could either import separate datasets for each symbol or use the multiple symbol map. The multiple symbol map only allows for eight different symbols and it sounds like you need nine?

    You could either do three separate imports with three symbols each or nine separate imports.

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  3. #3
    Roger Allen is offline Junior Member Yellow Belt
    Join Date
    Oct 2010
    Posts
    28

    Re: Pushpin color based on value AND shape based on type

    Many thanks for the quick reply, I will precode the data.

    How do I reference the pushpin type in a spreadsheet?

    Thanks again

  4. #4
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Re: Pushpin color based on value AND shape based on type

    Start with the Data Mapping Wizard, and choose the Multiple Symbol type map, you will see the options to specify different symbols (and colors) based on your data.

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  5. #5
    Roger Allen is offline Junior Member Yellow Belt
    Join Date
    Oct 2010
    Posts
    28

    Re: Pushpin color based on value AND shape based on type

    Sorry to be a PITA but I was trying to generate a spreadsheet (or CSV) that would set the symbol to be used, such as:

    Name / Lat / Long / Symbol#

    Is this doable?

    Thanks again

  6. #6
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Re: Pushpin color based on value AND shape based on type

    What spreadsheet are you using, can you post a sample in an Excel file? You could use some Excel formulas such as =IF(,,,) and concatenation.

    Then you could end up with a column like

    RedCircle
    GreenCircle
    GreenCircle
    RedSquare
    RedSquare
    etc.

    As long as there are less then eight variations you could import them all in one import and use the multiple symbol map.

    Otherwise import say with three separate imports, one could be all the Circles, the next all the Squares, etc.

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  7. #7
    Roger Allen is offline Junior Member Yellow Belt
    Join Date
    Oct 2010
    Posts
    28

    Re: Pushpin color based on value AND shape based on type

    I think I am asking the wrong question.

    In principle all I am trying to do is read a file with Lat/Long/PinType and put those pins on the map.

    Pins could be anything that is in the set, e.g. hotel / gas station / red circle etc etc

    Is it possible for MapPoint to read an excel file with a list of locations and a definition of the pin to put at that location?
    If not an excel file, is there any file type that I can create outside of MapPoint that will allow me to do this?

    Thanks

    Roger

  8. #8
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Re: Pushpin color based on value AND shape based on type

    Yes, definitely... you can use the Data Import Wizard to import an Excel file worksheet and use the Multiple Symbol Map. Note that the Multiple Symbol map limits you to eight different pushpins, so if you need more than eight symbols, maybe you can split up your worksheet into groups of less than eight pushpins.

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Radius-based statistics?
    By tdang in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 06-05-2009, 02:00 AM
  2. place a pushpin based on longitude n latitude using vba
    By chas in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 09-06-2006, 03:37 PM
  3. Selecting Shape Based on Name
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 09-07-2004, 11:01 AM
  4. Web based software
    By kwargo in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 04-03-2004, 11:32 AM
  5. I have territories based on Counties. I have also....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 03-27-2002, 01:11 PM

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 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127