Microsoft Office Tutorials and References
In Depth Information
Changing the Chart Options
Bubble: These charts are similar to
scatter charts but compare three sets of
values by displaying a series of circles.
Chart Tools tabs
Cylinder, Cone, and Pyramid: Excel
uses these three chart types to create
a column or bar chart using
threedimensional cylindrical, conical, or
pyramid shapes.
3. Choose a chart subtype. Depending on the
chart type, some chart subtypes show the
data series next to each other; others show
the data elements stacked on top of each
other. Some charts are two-dimensional, and
others are three-dimensional. As you see in
Figure 13-8, Excel creates the chart on the
worksheet where your data resides. The chart
is an object on the sheet and floats on top of
the sheet. You will discover later in this
chapter how to resize, modify, or move the chart.
Also, notice in Figure 13-8 that three new
Chart Tools tabs appear on the Ribbon.
Figure 13-8
Creating an Excel chart.
Multiple Charts
Workbooks can contain multiple charts. Excel
saves all charts as part of the workbook.
Changing the Chart Options
You just discovered how simple it is
to create a chart. But you probably will want
to enhance your chart to improve its
appearance. Some of the items you can change include
the size, style, color, and placement.
data, and the chart is selected, you see eight dotted
handles around the outer edge of the chart as well
as a thick colored line. Each chart, no matter where
it resides, has two windows. The outer window is a
frame in which the chart appears. When a chart is
on a sheet by itself, that frame is the entire sheet.
When the chart is an object on a worksheet, the
frame appears as the box that surrounds the chart.
However, like many other Excel features, you must
select the area you want to change before you can
change it. When a chart is on the same page as the
Search JabSto ::




Custom Search