Excel for Marketing Managers

Cartesian Coordinate Grid

Cartesian
Coordinate
Grids

Using the Application.................................................................................................................

To insert this graph into a Word document, highlight cells A1:P16, and select

Edit → Copy (shortcut: Ctrl+C). Move to your Word document. Select Edit →

Paste Special → Picture (Windows Metafile). Excel will insert the grid into

your Word document. It is now technically a picture, so you can move or resize

it within the document. Just be sure to resize using one of the corner diagonal

arrows to retain the correct proportions. And, as with any picture, you can have

Word align text to the left, right, or around your coordinate grid.

Excel Extras

Grids with Points or Lines

If you want to get fancy, you can also use the Drawing tools to place points or

lines on the graph before inserting it into Word. For lines, use the same process

that you used to place the axes on the grid. For points, use the Oval tool to

make a small circle.

1. Draw a small circle.
   First, turn off Snap To Grid, or you won’t be able to make a circle smaller

Figure 67

Using Paste

Special to insert

a picture