Microsoft Excel is a versatile program that offers many popular spreadsheet functions. However, the software also contains features for the construction and manipulation of graphics. The program can create customised maps out of simple existing images. These maps can suit a wide range of applications. Thematic maps quantify different measurements in different locations by displaying varied colours. Interactive maps allow users to build detailed views of a standard map to isolate certain locations or events. Once a map is created in Excel, the possibilities are limited only by your creativity.
- Skill level:
Other People Are Reading
Things you need
- Microsoft Excel
- Map image
Download or scan a starter map image. Many free maps are available for download at www.enchantedlearning.com/usa/states. Right-click any map and choose the "Save As" command to place the map on your computer.
Launch Excel. Select the entire worksheet by clicking in the selection box located between the column A and row 1 labels in the upper left of the spreadsheet.
Click the "Format" menu and choose the "Column" submenu. Select the "Width" command. A pop-up window will appear.
Type the number "2.0" into the column width field and press the "OK" button.
Select the "Format" menu again. Choose the "Sheet" submenu. Click on the "Background" command. A pop-up window will appear.
Browse to the location of the saved map image you downloaded or scanned. Click on the name of the map image file and press the "Insert" button.
Click on the "Tools" menu. Select the "Options" command. A pop-up window will appear.
Click the "View" tab of the pop-up window.
Uncheck the following boxes: "Row & column headers," "Vertical scroll bar," "Horizontal scroll bar" "and "Gridlines." This will ensure that the map image appears clean without interference from the spreadsheet grid.
Tips and warnings
- Excel may attempt to "tile" the map image by repeating it multiple times both horizontally and vertically. You may choose not to print these other areas by using the "File" menu's "Print Area" feature. Alternatively, hide the duplicate maps from the software view by selecting multiple columns and rows and using the "Paint" or "Fill" colour command on the "Drawing" toolbar to colour over them.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for