Microsoft Office Tutorials and References
In Depth Information
Connecting series points to a trendline
Figure 5-23: This chart uses error bars to depict corresponding
monthly sales from the previous year.
The daily data appears in range A1:A9. Additional calculations were made for
the data that appears in the chart. Row 13 contains the calculated average, which is
the data used for the columns in the chart. Formulas in rows 14 and 15 calculate the
maximums and minimums. Formulas in rows 16 and 17 calculate the data that’s
used for the error bars. The formulas in row 16 subtract the average from the
maximum, to yield the values used in the “+” range for the error bars. The formulas in
row 17 subtract the minimum from the average to get the values used in the “–”
range for the error bars.
Connecting series points to a trendline
If you add a trendline to a chart, you can use error bars to indicate the deviations
between the actual and the predicted values. Figure 5-25 shows an example.
Search JabSto ::




Custom Search