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® Excel® 2010 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
