Show Statistical Lines

You can use statistical lines to indicate minimum, maximum, mean, standard deviation, logarithmic regression, linear regression, or custom values. Statistical lines are series-based. When applying a statistical line to a chart with multiple series, you must specify the series to which the statistical line applies. You can specify the line type and the color of each statistical line independently.

You can set statistical lines on all displays, except 3D bar and pie displays. You cannot use standard deviation or logarithmic regression lines in a scatter display.

Steps

1. Click the arrow to the right of the Chart button and then click Chart Options.
2. Click the Statistical tab.
3. For each statistical line, specify the calculation, line type, and color that you want to apply.

If you are defining statistical lines for more than one display, indicate the series to which each statistical line applies.

4. Click Apply and click OK.