Microsoft Office Tutorials and References
In Depth Information
Inserting a Chart
Generating Excel Charts
each compares data in a different manner
(see Figure 13-5). Some of the most
commonly used chart types include the following:
Area: Area charts display the trend of
each value, usually over a specified
period of time.
Scatter: These charts include two
value axes, one showing a set of
numerical data along the x-axis and the
other showing data along the y-axis.
Surface: This shows trends in values in
a continuous curve.
Select the chart type appropriate for your data.
Doughnut: This displays data similarly
to a pie chart; it compares parts to a
whole but contains multiple series.
Column: Column charts compare
values to categories using a series of
vertical columns to illustrate the series.
Stock: Stock charts are usually (but not
exclusively) used to illustrate the
fluctuation of stock prices. In a stock chart,
the data order is very important and
usually the row headings are High,
Low, and Close (or Open, High, Low,
and Close). See Figure 13-7 for an
example of a stock chart.
Bar: Bar charts, like column charts,
compare values to categories but use a
series of horizontal bars to illustrate the
Line: Line charts are similar to bar
charts but use dots to represent the
data points and lines to connect the
Pie: This chart compares parts to a
whole. Usually a pie chart has only one
data series. Figure 13-6 illustrates data
appropriate for a pie chart.
Easily track stock progress with a stock chart.
Pie chart data.
Radar: This displays changes in values
relative to a center point by comparing
the cumulative values of multiple data