Excel for Marketing Managers

Cartesian Coordinate Grids

Cartesian

Coordinate

Grids

Cartesian Coordinate Grids

Opportunity..................................................................................................................................

There are times when you need a few sheets of grid paper for sketching or
graphing activities, or times when you would like to be able to insert a small
Cartesian coordinate grid into a test or quiz written in Word. There are all
sizes and types available in books and workbooks, but cutting them out and
taping them to a document before printing is a big hassle. You may also want a
handout sheet with the same size grids on them for homework assignments.

Solution and Overview

By adjusting row and column widths and using borders, you can create any size
grid you want, up to a full page. And, by using the drawing tools, you can
create a grid with arrows on the x- and y-axes, or add points or lines to the
grid. You can then copy and paste these grids into a Word document.

You will make a small 16 x 16 grid, with arrows on the ends of the x-axis and
the y-axis.

Creating the Solution

1. Set the column width so that it is the same as the row height.
   Start with a blank Excel worksheet. Move your mouse cursor on the line
   between the 1 and 2 in the row headings until it changes into a plus sign
   with horizontal arrows. See Figure 58 on the following page. When you left-
   click your mouse, you will see “Height 12.75 (17 pixels)”.