10. Presenting Excel Data on a Map Using Microsoft MapPoint
Plotting Data Geographically
In many cases, the best way to present data is to plot it on a geographic map. Mapping software used to cost thousands of dollars. However, Microsoft offers a product called Microsoft MapPoint 2010. MapPoint is available in editions for North America and Europe.
Figure 10.1 shows a Starbucks database plotted on a map. Note how the stores are concentrated in the heart of the city, but appear in any semi-populated region. Any dataset with a geographic component such as street addresses, zip codes, postal ...