Microsoft Office Tutorials and References
In Depth Information
The Format Error Bars
dialog box appears.
5
Click Vertical Error Bars.
5
The Vertical Error Bars
options appear.
l
6
6
Click to choose a
direction (
changes
to ).
Click Both if you want
to show the possible
error amount above
and below the observed
value.
Click Minus if you want
to show the possible
error amount below the
observed value.
7
8
9
0
Click Plus if you want to show the possible
error amount above the observed value.
7
Click to choose an end style (
changes
to
).
8
Click to choose an error amount type
(
changes to
).
9
Type a value, if necessary.
0
Click Close.
l The chart appears with error bars.
Did You Know?
Your confidence level in estimating
population characteristics assumes
that the sampled values are
normally (evenly) distributed
around the mean, as in a bell
curve.
Did You Know?
You can add trendlines and error
bars to a PivotChart. However, if you
make changes to your PivotChart,
Excel may remove the trendlines or
error bars. Changes that may result
in the loss of trendlines or error
bars include changing the layout,
removing fields, and hiding or
displaying items.
Did You Know?
Only certain chart types support
error bars, including 2-D area, bar,
column, line, and XY scatter charts.
These types let you create error
bars for the values measured by
the y axis. For the scatter chart,
you can create both X and Y
error bars.
Chapter 6: Create Charts
147
 
Search JabSto ::




Custom Search