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

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

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

How do I reference the pushpin type in a spreadsheet?

Thanks again

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

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

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

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

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