Microsoft Office Tutorials and References
In Depth Information
The Chart Tools Ribbon Tabs
Charting 101
Excel is loaded with different chart types, some of which are explained in more
detail later in this chapter. For now, it’s best to stick to some of the more easily
understood choices, like Bar, Column, or Pie. Remember, the chart choices are
just the starting point, as you’ll still be able to configure a wide range of details
that control things like the titles, colors, and overall organization of your chart.
3. Clickthesubtypeyouwant.
Excel inserts a new embedded chart alongside your data, using the standard
options (which you can fine-tune later).
Note: If you don’t want to make any choices, you can actually build a chart with one key press. Just
highlight your data and press F11. This step creates a column chart on a new worksheet. Although you can’t
undo this operation, you can always delete the new chart worksheet and start over.
Figure 19-2:
Under each chart
choice are yet more
subtypes, which add
to the fun. If you
select the Column type
(shown here), you’ll
get subtypes for
twoand three-dimension-
al column charts, and
variants that use cone
and pyramid shapes.
If you hover over one
of these subtypes, a
box appears with a
brief description of
the chart.
The Chart Tools Ribbon Tabs
When you select a chart, Excel adds three new tabs to the ribbon under the Chart
Tools heading. These tabs let you control the details of your charts, and they are:
Design . This tab lets you change the chart type (page 525) and the linked data
that the chart uses (page 515). It also lets you choose a chart style and layout,
two ways to improve the appearance of a chart that you’ll consider starting on
page 531.
 
Search JabSto ::




Custom Search