Microsoft Office Tutorials and References
In Depth Information
Choosing a Chart Type
Here you’re shown a collection of basic chart types, each of which offers several
subtypes that let you portray your data in different ways, with different looks. Table 6–2
briefly describes them.
Table 6–2. Chart Types
Chart Type
What It Does
When to Use It
Depicts data as vertical bars; perhaps the
most commonly used type
When you need to present
individual sets of data (e.g., sales
totals by different departments)
Depicts data as a series of lines
When you want to present data
that varies over time (e.g., a
student’s test scores)
Characterizes only one data series as a
series of slices, each contributing to a
If, for example, you need to portray
different departments’ percentages
of an overall company budget
Basically depicts a column chart whose
data series are presented horizontally
instead of vertically
As per a column chart, but here the
data bars extend sideways
Depicts a line chart whose data fills in the
areas between the lines and the x-axis
(take a look at the Area button)
When you want to convey the
relative depth of data (e.g., a test
score of 90 will cover more area
than a score of 75)
Portrays data along two value axes (that
term will be defined shortly), thus treating
data as paired values.,
When you want to look at data
organized by two quantitative
variables at the same time, e.g.,
plotting marathon times by age of
the runners.
Encompasses a collection of
lesscommonly used charts.
When you need a specialized
chart, such as for a stock market
Search JabSto ::

Custom Search