June 2005
Intermediate to advanced
568 pages
24h 7m
English
Content preview from Mapping Hacks
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
46
|
Chapter 1, Mapping Your Life
#13 Add Maps to Excel Spreadsheets with MapPoint
HACK
HACK
#13
Add Maps to Excel Spreadsheets with
MapPoint Hack #13
If you have both Microsoft Excel and Microsoft MapPoint, you can add maps
to your spreadsheets with a few clicks.
A lot of people manage address lists and other address-based data in
Microsoft Excel, but while Excel provides all kinds of graphing capabilities,
it doesn’t know much about maps. If you add Microsoft MapPoint to your
system (another $250, admittedly), you can show your Excel data on a map
quite easily.
As the November 2004 election is coming up as I’m writing this, I’ve been
doing a lot of work with voter registration rolls. One of my spreadsheets,
actually an export from Access, is a list of street addresses and party affilia-
tions, as shown in Figure 1-28.
Because MapPoint 2004 is installed on the same computer, Excel shows an
extra toolbar button to the left of the font-choice drop-down box. Clicking
on that button inserts a MapPoint object on the spreadsheet and also starts
up the Link Data Wizard, shown in Figure 1-29. (If you have more than one
area of data on the spreadsheet, select the part you want to map before
clicking the button.)
MapPoint will make an educated guess about data types based on headers in
the document, and you can use the drop-down boxes to correct it if it’s wrong.
MapPoint will accept a variety of geographic data ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.