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
Column
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)
Line
Depicts data as a series of lines
When you want to present data
that varies over time (e.g., a
student’s test scores)
Pie
Characterizes only one data series as a
series of slices, each contributing to a
whole
If, for example, you need to portray
different departments’ percentages
of an overall company budget
Bar
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
Area
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)
Scatter
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.
Other
Encompasses a collection of
lesscommonly used charts.
When you need a specialized
chart, such as for a stock market
comparison
 
Search JabSto ::




Custom Search