Excel for Marketing Managers

Cartesian Coordinate Grid

Cartesian
Coordinate
Grids

Click on the gray box with the A in it at the top of column A. Left-click and

drag to the right, and watch as Excel counts the columns for you (1C, 2C,

etc). When the count reaches 16C (column P), stop.

2. Set the row height.
   Now, move your cursor to the line between A and B in the column headings
   until it changes into a plus sign with vertical arrows. You will see “Width:
   8.43 (64 pixels)”. Click on the plus sign and drag to the left until it reads
   “Width: 1.71 (17 pixels)”. All of the highlighted columns will now have the
   same width.


3. Select the grid area.
   Place your cursor in cell A1. Click and drag to highlight over to column P
   and down to row 16.


4. Format the grid area.
   Press Ctrl+1 (that’s the Ctrl key and the number 1) to access the Format
   Cells dialog box; select the Border tab. On the right side of the dialog box,
   under Style, make sure that the bottom line in the left column is high-
   lighted. Now, at the top, under Presets, click on Outline and Inside, and
   then click OK. You now have a basic coordinate grid that measures from –8
   to +8 along both the x- and y-axes.

Figure 58

Plus sign cursor with vertical arrows indicates that

you are ready to change the row height

Figure 59

Setting columns to the same width