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 ...

Get Charts and Graphs: Microsoft now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.