How to Make a Grid Map With Excel 2007

Written by jim skelter | 13/05/2017
How to Make a Grid Map With Excel 2007
Enter Excel data into Map Point to create a grid map with data plots. (Burke/Triolo Productions/Brand X Pictures/Getty Images)

Microsoft Excel is spreadsheet software that can be used to create graphs and charts as well as grid maps. Before 2007, Microsoft Excel came with map-making software installed. With the release of Microsoft Excel 2007, map-making software no longer comes with the Excel package, so you need additional software to do the job. Microsoft MapPoint works with Excel 2007 to integrate maps into Excel data.

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.

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 customise your map and then creates a map according to your specifications.

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."

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.

Things you need

  • Microsoft Excel
  • Microsoft Map Point

Show MoreHide

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.