PDA

View Full Version : numbers



PVC
11-29-2011, 07:14 AM
i am a total novice so excuse for asking simple things. Can i place next to a town a number that corresponds to that town. I have a list in excel with names of town and the number of clients out of that town. I want to put those numers on the map.

Eric Frost
11-29-2011, 09:54 AM
You can use the built-in Pushpin Symbols, I think they have numbers up to fifty. Alternatively, you could use custom Pushpin Symbols, e.g. Welcome to Pushpin City! — Provider of MapPoint Pushpin Symbol Sets and Tools for Creating and Managing Custom Pushpin Symbols (http://www.pushpincity.com/)

What version of MapPoint are you using? Also, how high do you need the numbers to go?

You could write a simple Macro to place the Pushpins and Symbols at the same time if doing it manually gets to be too much work, there are lots of examples of Excel VBA macros in the MapForums Downloads section ($99) http://www.mapforums.com/mapforums-plus-downloads/ or I'm sure someone in here could help you put one together for a fee.

hope this helps.
Eric

Eric Frost
11-29-2011, 10:13 PM
Another thought --
Just import the numbers as the Name item in the import, and make them Name Only items in the Pushpin Balloon.

Perhaps if you post a tiny sample of your data or fake data I could suggest the steps to do it.

Eric

PVC
11-30-2011, 12:47 AM
my excel sheet looks like this:

city number of students
Brussels 10
Gent 20
Antwerpen 25

I want to plot those numbers on the map of Belgium near the name of the city.

Thanks a lot for the help

Eric Frost
11-30-2011, 07:28 AM
Here's what it could look like with "Name Only" balloons.

BTW, have you been to Bruges? I liked the movie.

Eric

PVC
12-01-2011, 01:25 AM
Thanks for the answer. It helps me on the way. Is it posible to make all the names to appear at onces. Now i have to right click on every city and then activate show name.

What is the differance between the mappoint america and europe?

Eric Frost
12-01-2011, 06:01 AM
The "Pushpin Tool" ($75) allows you to do this in batch Pushpin Tool Add-in - MP2K Magazine (http://www.mp2kmag.com/downloads/pushpin.tool/)

MapPoint North America has maps of Europe and MapPoint Europe has mapping data for the United States, Canada, and Mexico (also Puerto Rico).