Microsoft Office Tutorials and References
In Depth Information
Exploring chart elements
A data marker is a symbol on the chart that represents a single value in the worksheet, such as
a bar in a bar chart or a wedge in a pie chart. A group of related data markers (such as all the
green columns in the example on the previous page) constitute a single data series.
Understanding chart types
Excel of ers several dif erent chart types so that you can select one that corresponds best to
the data you want to present. Excel also makes it easy to change the chart from one type to
another once it is complete. The following table lists the 11 chart types that Excel of ers.
Shows the relative importance of values over time. An area
chart emphasizes the magnitude of change over time more
than a line chart does.
Emphasizes the comparison between items at a fixed period
of time. Values are marked on the horizontal grid, and so the
data markers appear as horizontal bars.
A type of XY chart that uses three values instead of two.
In the third data series, Excel displays the plot points as
bubbles; the larger the bubble, the larger the value.
Shows variations in data over a period of time, or compares
individual items. Categories appear horizontally and values
Shows how individual parts relate to a whole. A doughnut
chart can display multiple data series, with each ring
representing a different series.
Shows how a data series changes over time, emphasizing
trends rather than amount of change.
Shows the relationship of parts to a whole. Only one data
series is used.
Shows changes in multiple data series relative to a center
point as well as to each other.
Shows the fluctuation of values over a certain time period,
such as stock prices or temperature fluctuations.
Plots trends in values across two dimensions in a continuous
curve, and applies color to indicate where data series are in
the same range. This is useful for comparing two data series
to find the best combinations between them.
Shows the relationship between numeric values in multiple
data series that may not be apparent from looking at the
data. In an XY chart, both axes show values.