Although Microsoft Excel can create a variety of graphs and charts, creating maps is not one of the spreadsheet's options. For Excel 2000 and later, Microsoft created MapPoint to integrate with Excel and create maps. MapPoint is a powerful tool that can help you create information-rich maps that can be integrated not only with an Excel spreadsheet, but also with GPS devices as well. MapPoint uses your existing Excel worksheet data to create a map that can be pasted into most Microsoft products, including Word, PowerPoint and Excel.
Ensure that your date is organised neatly. Data that will transform well to maps is clearly organised into rows and columns, with column headers. For example, you might have a list of cities (with the column header "City"), a list of Postcodes ( header "ZIP codes"), and a list of the number of people who live in those Postcodes (header "people").
Copy the data in your worksheet. Click on the top right cell and drag the mouse over to the bottom right cell. Click "Ctrl-C" to copy the data.
Press "Ctrl-V" in MapPoint. Microsoft will paste your data into a map. MapPoint will recognise your pasted data as geographical data, and will open the "Data Import" wizard.
Select the type of map you want to create. Click "Finish."
Click "Edit" in MapPoint. Click "Copy" to select the detailed map,
Click "Ctrl-V" to paste the map into the Excel worksheet. Excel pastes the map into the worksheet as a bitmap.
To copy the legend in addition to the map, select "Copy Map" from MapPoint when you go to copy the map from the "Edit" menu.
Tips and warnings
- To copy the legend in addition to the map, select "Copy Map" from MapPoint when you go to copy the map from the "Edit" menu.