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
Search JabSto ::




Custom Search