Microsoft Office Tutorials and References
In Depth Information
Adding a Clustered Cylinder Chart to the Worksheet
5
Drag the chart down
and to the left to
position the upper-left
corner of the dotted
line rectangle over the
upper-left corner of
cell A11.
Press and hold down
the mouse button
while pointing to
the middle sizing
handle on the right
edge of the chart
(Figure 1– 58).
upper-left corner of
chart area moved
to upper-left corner
of cell A11
How does Excel know
which data to use to
create the chart?
Excel automatically
selects the entries in
the topmost row of
the chart range (row 3)
as the titles for the
horizontal axis (also
called the x-axis or
category axis ) and draws a column for each of the 30 cells in the range containing numbers.
mouse pointer
changes to
crosshair
Figure 1–58
6
While continuing to
hold down the mouse
button, press the ALT
key and drag the right
edge of the chart to the
right edge of column H
and then release the
mouse button to resize
the chart.
Chart Styles gallery
More button
Press and hold down
the mouse button
while pointing to
the middle sizing
handle on the bottom
edge of the selection
rectangle and do not
release the mouse
button (Figure 1– 59).
chart resized so that
right edge of chart
aligns with right edge
of column H
mouse pointer
changes to
crosshair
Why should I hold the
ALT key down while
I resize a chart?
Holding down the ALT
key while you drag a
chart snaps (aligns)
the edge of the chart
area to the worksheet gridlines. If you do not hold down the ALT key, then you can place
an edge of a chart in the middle of a column or row.
Figure 1–59
 
Search JabSto ::




Custom Search