Community of VE/MapPoint Users and Developers
This is a discussion on noob help with counties within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; How do you get it to show the counties in the state view. I can see them at a multi ...
| |||||||
| Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| |||
|
There may be an easier way, but this works and took about ten minutes. The technique involves using MapPoint's built-in demographic data to export counties to Excel, then importing the counties back into MapPoint as custom territories. Here are the steps in MapPoint 2004: 1. Select Data/Data Mapping Wizard... from the MapPoint main menu 2. On the "Data Mapping Wizard-Map Type" dialog box, click on the "Next>" button 3. On the "Data Mapping Wizard-Data Set" dialog box, click on the "Next>" button 4. On the "Data Mapping Wizard-Data Fields" dialog box, select "County" in the "Show the day by" list and then click on the "Finish" button 5. Using one of the drawing tools, surround the region for which you want counties on the map 6. Select the Data/Export to Excel menu options 7. In Excel, clean up the data with the following quick steps: - Delete the MapPoint worksheet as you do not need it - Delete the column containing the "Area in Square Miles by County" as you do not need it - Delete the "Set0" named range (simplifies import step later) - Sort the data by State and then delete any extra counties (if there are any) - Copy the entire County column and create a new column with the same data. The column heading should be Territory - Save the file 8. Back in MapPoint, select the Data/Territories… menu options 9. On the "Create Territories Wizard-Method" dialog box, click on the "Next>" button 10. On the "Create Territories Wizard-Import or Link" dialog box, click on the "Next>" button 11. Select the Excel file containing the county data and click on the "Open" button. 12. On the "Import Territories Wizard" dialog box, click on the "Finish" button You now have a set of territories corresponding to the counties of the selected region. |
![]() |
| Tags |
| counties, noob |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Sharing Counties, Map Layers, Possible? | jlssa | MapPoint 2006/2009 Discussion | 1 | 06-20-2005 10:56 AM |
| Manual Placements and Counties | wadams | MapPoint 2006/2009 Discussion | 2 | 05-12-2005 01:52 PM |
| show ONLY the counties in my territory | eieio59 | MapPoint 2006/2009 Discussion | 1 | 08-24-2004 09:37 PM |
| TEXT WITHIN COUNTIES | Anonymous | MapPoint 2006/2009 Discussion | 0 | 07-09-2004 01:54 PM |
| Clickable counties (polygons) | najones | MapPoint 2006/2009 Discussion | 0 | 12-01-2003 05:52 PM |