Microsoft Office Tutorials and References
In Depth Information
An AutoShape can be added to a worksheet’s drawing layer or added to a chart. To
insert an AutoShape on a worksheet, start by selecting any cell. To insert an
AutoShape into a chart, start by activating the chart. Next, click the category (for
example, Basic Shapes), click a shape, and then drag in the worksheet (or chart) to
create the AutoShape. When you release the mouse button, the object is selected
and its name appears in the Name box (see Figure 6-2).
Figure 6-2: This AutoShape was drawn on the worksheet. Its name
(AutoShape 3) appears in the Name box.
If a chart is not activated when you insert the AutoShape, you can still insert
an AutoShape on top of a chart. The AutoShape may appear to be added to
the chart, but it will actually reside on the worksheet’s drawing layer (this is
usually not what you want). Consequently, it will not be moved or resized
with the chart.
A few of the AutoShapes require a slightly different approach. For example,
when adding a FreeForm AutoShape (from the Lines category), you can click
repeatedly to create lines. Or, click and drag to create a nonlinear shape.
Doubleclick to finish drawing and create the AutoShape. The Curve AutoShape (also in the
Lines category) also requires several clicks while drawing.
Following are a few tips to keep in mind when creating AutoShapes.