Mapping Hacks

Add Maps to Excel Spreadsheets with MapPoint #13

Chapter 1, Mapping Your Life

|

51

HACK

Unfortunately MapPoint doesn’t let me choose to keep the two Working

Families voters in the list, but 2 out of 841 voters and 1 of 542 addresses is

probably okay for this demonstration. The next screen, shown in

Figure 1-37, lets you choose the symbols to use on the map to represent dif-

ferent affiliations.

The drop-down boxes let you choose symbols and colors, and you can also

change the labels used. In this case, because many of these houses are right

next to each other, I chose the smallest symbol available and used color to

distinguish party.

When I’m done, I have a completed map, shown in Figure 1-38.

The house-by-house presentation looks better when you zoom in further, as

shown in Figure 1-39.

Figure 1-35. Choosing the particular data behind the symbol

Figure 1-36. An error, as MapPoint has a limited number of multiple symbols supported

at once

52

|

Chapter 1, Mapping Your Life

#13 Add Maps to Excel Spreadsheets with MapPoint

HACK

As long as you open the spreadsheet on a (Windows) computer running

MapPoint, you’ll be able to zoom around the map, change the icons, link

new data, and more. You can also open the map in the full MapPoint pro-

Figure 1-37. Choosing symbols for the data

Figure 1-38. A completed map