Microsoft Office Tutorials and References

In Depth Information

**Adding error bars**

Figure 19-10
Using the Format Trendline task pane, you can add six types of trendlines to a data

series.

To specify the type of trendline or moving average you want, select one of the six options

at the top of the task pane. If you choose Polynomial, indicate the highest power (from 2

through 6) for the independent variable in the adjacent Order text box. If you select

Moving Average, indicate the number of periods Excel should use in its calculations.

After you choose the type of trendline you want, you can use the Trendline Name area of

the task pane to customize the name that appears in the chart’s legend. Options under

Forecast (not available for moving averages) let you extrapolate the trendline. If you’re

adding a linear, polynomial, or exponential trendline, you can also select the Set Intercept

check box to use a y intercept and then specify the y-intercept value in the box on the

right. Select the Display Equation On Chart and Display R-Squared Value On Chart check

boxes to display the regression equation and R-squared value on the chart.

Adding error bars

When you plot statistical or experimental data, it’s often helpful to indicate the confidence

level of your data. The error-bar feature makes this easy. To add error bars to a data series

in an area, bar, column, line, or X Y (scatter) chart, select the series, click the Chart Elements