Microsoft Office Tutorials and References
In Depth Information
Chart types that support error bars
Fixed value: The error bars will be offset from each data point by a fixed
amount that you specify. Each error bar will be the same height (or same
width, for X error bars).
Percentage: The error bars will be offset from each data point by a
percentage of the data point’s value. For example, if you specify 5 percent as
the percentage, a data point at 100 would display error bars at values 95
and 105. Error bars based on percentage will vary in size.
Standard deviation(s): The error bars will be centered along an invisible
line that represents the average of the data series values, plus or minus the
number of standard deviations specified. For this option, the error bars are
fixed in size, do not vary with each data point, and are always parallel to
an axis.
Standard error: The error bars will be offset from each data point by the
standard error. The standard error is the standard deviation, divided by the
square root of the sample size. Each error bar will be the same height (or
same width, for X error bars).
Custom: The error bars will be determined by the values in a range you
specify. Usually, this range contains formulas.
Figure 5-20 shows a chart that uses error bars to indicate sampling error in a
poll. Note that, in this example, the error bars use the Fixed Value option, with a
value of .035 to represent a sampling error of 3.5 percent. It does not use the
Percentage option, which displays as a percentage of each data point.
Figure 5-20: This chart uses error bars to indicate sampling error in a poll.
Search JabSto ::




Custom Search