How to Make a Grid Map With Excel 2007
- 1). Enter the data you want to map into an Excel spreadsheet. For example, to make a map of crime rates by city, you could enter the cities in the first column, states in the second column and the number of crimes committed in each city in the third. Enter all data that will be represented on the grid map.
- 2). Open MapPoint and create a blank map. Copy your Excel data and post it into MapPoint. Pressing CTRL+V will open the Data Import Wizard. The Data Import Wizard allows you to customize your map and then creates a map according to your specifications.
- 3). Choose "Grid Map" under "Map Type" in the Wizard. You also can select the columns of data you want to show on the map. Click "Finish."
- 4). Go to the "MapPoint Edit" menu and click "Copy Map." Go back to your Excel spreadsheet and press CTRL+V. This will paste the map into your Excel spreadsheet.
Source...