Excel for Marketing Managers

Cartesian Coordinate Grids

Cartesian

Coordinate

Grids

6. Draw the x-axis.
   Click on the word AutoShapes, select Lines, and then click on the double
   arrow line. Your cursor should now be a small plus sign. Move the cursor to
   cell A8, click on the bottom line of the cell, drag to cell P8, and let go. You
   should now have a double arrow line to indicate the x-axis. Change the line
   thickness by clicking on the Line Style icon on the Drawing toolbar (three
   horizontal lines) and select 1½ point.


7. Draw the y-axis.
   Repeat Step 6, except start the arrow at the right edge of cell H1 and drag
   down to H16. Click anywhere off the grid to turn off Drawing tools.


8. Select View from the drop down menus, and then Zoom. Click on 100%, and
   then OK. Save your worksheet as Coordinate Grid.

Figure 65

Selecting double arrow line format

Figure 66

Selecting line thickness