Excel for Marketing Managers

Cartesian Coordinate Grids

Cartesian

Coordinate

Grids

than the cell you start in. Next, click on the Oval icon in the Drawing tool-

bar (right next to the rectangle). Click anywhere on your grid, keep the left

mouse button down, and drag around.

2. Adjust the size of the circle.
   By adjusting the size of the two axes, you can make a very small circle. It
   does eventually reach a minimum size, which should be about right.
   If you are having difficulty seeing what you are doing, use View and Zoom
   to adjust the screen to 200%. When the circle is the right size, release the
   mouse button and you will have a small circle surrounded by four circular
   grab handles.


3. Add color to the circle.
   Use the Fill Color tool to make the dot black instead of transparent. Find
   the Paint Bucket icon in the Drawing toolbar. If it has a bar of black un-
   derneath it, simply click on it and the circle you just made will turn black.
   If it is some other color, click on the small arrow to the right of the paint
   bucket to select black from the color palette.


4. Move the circle into place and label.
   Move your cursor over the black circle. When it changes to a plus sign with
   four arrows, left click and move your point to where you want it on the grid.
   Click on one of the cells near it, and type in a letter to label it. If you want,
   keep the dot off to the side of your grid before saving. Then, by using copy
   and paste, you can make as many circles as you need for a particular Word
   document.

Figure 68 Selecting shape and fill color of a dot