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.