Browse » Home
Monday, January 28, 2013
How to Create Maps in Excel 2007
1. Create your data in an Excel spreadsheet. For example, if you want to map sales figures by zip code, you could put the sales data in one column and zip codes in another. In a third column, write the name of the city that corresponds with the zip code. For example:
$50,000_32206_Jacksonville, FL
$43,000_12801_Glen's Falls, NY
$19,000_80537_Loveland, CO
2. Select the data that you would like to include in the map. Highlight the data by holding down the left mouse key while you mouse over the area. When the data is selected, hit CTRL C to copy the data.
3. Open a blank map in MapPoint. Paste the data you copied from Excel into MapPoint by pressing CTRL V. This will open the Data Import Wizard.
4. Choose the type of map you would like to create and which columns you want to show. Click Finish.
5. Click Copy Map (located on the MapPoint Edit menu). Return to Excel and press CTRL V to paste the map into your spreadsheet.