PDA

View Full Version : Display Totals on Map



rleash
09-02-2009, 02:55 PM
I apologize if this has been asked before, but I could not find it.

I've imported data from Excel with 2 columns, Zip and Tickets. I made a color-coded map based on the sum of tickets by County. When I put my mouse over the county name, a popup comes up telling me what the 'Sum of Tickets' is for that county. I can also export these totals into Excel. But what I would really like is for the numbers to be displayed right on the map, without having to mouse over.

Is there any way to do this?

Mattys Consulting
09-02-2009, 07:49 PM
Yes, it can be done.

I'd run through the Zip and Tickets columns with a tool
made for this purpose, creating bitmaps of the amount
and naming it by the Zip. Then I have code run to assign
each bitmap to the appropriate pin on the map.

Mike Mattys
Mattys Consulting - Custom Programming (http://www.mattysconsulting.com)

rleash
09-03-2009, 02:57 PM
Thank you, but after spending some time with this yesterday, I found a much easier solution I'll post in case others have the same problem as I.

After making the color-coded map, I exported it to Excel. This gave me a total by county. Then I made a Territory, by importing the same information it just exported. I used the Totals as the Territory labels, and voila!

donaldc
09-03-2009, 05:11 PM
Hi,

I'm interested in your method. Could you explain how you did this?

You said, "After making the color-coded map, I exported it to Excel. This gave me a total by county. Then I made a Territory, by importing the same information it just exported. I used the Totals as the Territory labels, and voila!"

1) Did you make a shaded map based on the tickets/data you were working with?
2) How do you choose your Territory label?

rleash
09-03-2009, 05:25 PM
Sorry if I'm not using the right lingo.. I only started using MapPoint this week!

Yes, I first made a shaded map using my Zip/Tickets data. When making this map, I chose to "Show Data by: County", and "Combine the Data By: Adding the values". Once I had this map, I exported to Excel.

Then, I created the Territories from my own data, choosing the file it just created. In the "Import Territories Wizard," it asks how to match up the column headings (County to County, State to State, etc). But for the last column, showing the sums, I selected "Territory" (it's set to <Skip Column> by default).

And that's it!

donaldc
09-03-2009, 06:21 PM
That did it. Thanks!

Mattys Consulting
09-03-2009, 09:07 PM
Hi rleash,

Thanks! I didn't know it could be done that way.

Mike Mattys
Mattys Consulting - Custom Programming (http://www.mattysconsulting.com)

Ted Bundy
10-17-2009, 06:22 AM
Okay, I'm very interested in this feature but am fairly new to Mappoint. I created my shaded map and exported to excel but where in the world is the excel file saved and under what name. It just exports and give me no idea where to go and find this file so I can use it to create my territories.

Thanks

Ted Bundy
10-17-2009, 06:34 AM
UH Nevermind. I can't believe I searched all over for the excel file only to find that it had opened excel and was waiting for me to save. Thanks

Ted Bundy
10-17-2009, 06:37 AM
Okay that worked great but one more question. I have my territory by state and it displays the information great with one issue, if two states have the same number of units it only displays in one state and not in the other. For instance if Illinois and Arkansas sold 5 units it shows 5 in Illinois and nothing in Arkansas. Is there a way to get it to display in all states the data, even when it is the same as somewhere else in the territory without having to do it manually?

Thanks

rleash
10-17-2009, 04:55 PM
Try resizing your map slightly (zooming in or out a tiny bit). You can do this in small increments by right clicking and dragging across the map, to make a large square, and then click to zoom in. I've found that sometimes numbers don't like to show up unless the zoom level is positioned just right. You just have to play with it a bit.