Microsoft Office Tutorials and References
In Depth Information
Error bar alternatives
Next, create formulas to calculate the difference between each predicted Y value
and each actual Y value. In this example, cell D2 contains the following formula,
which was copied down to cell D11:
=C2-B2
The final step is to add Y error bars to the chart, using the Y Error Bars tab of the
Format Data Series dialog box. For this example, the Plus display option is used,
along with a Custom + error amount. The values used for the custom error bars are
in range D2:D11.
For data points in which the predicted Y value is greater than the actual Y value,
the error bar extends upward from the data point. For data points in which the
predicted Y value is less than the actual Y value, the error bar extends downward from
the data point. The sum of these deviations will always be 0.
Error bar alternatives
In some cases you may prefer to “roll your own” error bars by adding one or two
additional series to your chart. Figure 5-26 shows two charts. The chart on the top
uses standard error bars to display one standard deviation. The chart on the bottom
uses two additional series to plot lines that represent plus and minus one standard
deviation.
Figure 5-26: Using two additional series as a substitute for error bars
Search JabSto ::




Custom Search