Microsoft Office Tutorials and References
In Depth Information
EX 52
Excel Chapter 1 Creating a Worksheet and an Embedded Chart
Chart Tools
contextual tab
Click the 3-D Clustered Column
chart type in the 3-D Column area
of the Column gallery to add a
3-D Clustered Column chart to the
middle of the worksheet in
a selection rectangle.
Design tab
when chart is
selected, colored
borders in worksheet
indicate chart range
Click the top-right edge of the
selection rectangle but do not
release the mouse to grab the chart
and change the mouse pointer to
a cross hair with four arrowheads
(Figure 1–77).
Why is a new tab displayed on the
When you select objects such as
shapes or charts, Excel displays
contextual tabs that include special
commands that are used to work
with the type of object selected.
Because a chart is selected, Excel
displays the Chart Tools contextual
tab. The three tabs below the Chart
Tools contextual tab, Design, Layout,
and Format, are tabs that include
commands to work with charts.
mouse pointer
changes to cross hair
with four arrowheads
initial 3-D
Column chart
Figure 1–77
Continue holding down the left
mouse button while dragging
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.
Release the mouse button to
complete the move of the chart.
upper-left corner of
chart area moved to
upper-left corner of
cell A11
Click the middle sizing handle on
the right edge of the chart and
do not release the mouse button
(Figure 1–78).
How does Excel know how 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 25 cells in
the range containing numbers.
mouse pointer changes
to a cross hair
Figure 1–78
Search JabSto ::

Custom Search