Microsoft Office Tutorials and References
In Depth Information
Understanding Chart Types
Understanding
12
chapter
Chart Types
Excel offers 11 different types of charts, including
column charts, bar charts, line charts, and pie charts.
The chart type you use depends on the type of data
and how you want to present that data visually.
Chart Types
Chart Type
Description
Area chart
A chart that shows the relative contributions over time that each data series makes to the whole
picture.
Bar chart
A chart that compares distinct items or shows single items at distinct intervals. A bar chart is laid
out with categories along the vertical axis and values along the horizontal axis.
Bubble chart
A chart that is similar to an XY chart, except that there are three data series, and in the third
series the individual plot points are displayed as bubbles (the larger the value, the larger the
bubble).
Column chart
A chart that, like a bar chart, compares distinct items or shows single items at distinct intervals.
However, a column chart is laid out with categories along the horizontal axis and values along the
vertical axis.
Doughnut chart
A chart that, like a pie chart, shows the proportion of the whole that is contributed by each value
in a data series. The advantage of a doughnut chart is that you can plot multiple data series.
Line chart
A chart that shows how a data series changes over time. The category (X) axis usually represents a
progression of even increments (such as days or months), and the series points are plotted on the
value (Y) axis.
Pie chart
A chart that shows the proportion of the whole that is contributed by each value in a single data
series. The whole is represented as a circle (the “pie”), and each value is displayed as a
proportional “slice” of the circle.
Radar chart
A chart that makes comparisons within a data series and between data series relative to a center
point. Each category is shown with a value axis extending from the center point.
Stock chart
A chart that is designed to plot stock-market prices, such as a stock’s daily high, low, and closing
values.
Surface chart
A chart that analyzes two sets of data and determines the optimum combination of the two.
XY chart
A chart that shows the relationship between numeric values in two different data series. It can
also plot a series of data pairs in XY coordinates. (This is also called a scatter chart.)
Search JabSto ::




Custom Search