Export (0) Print
Expand All
Expand Minimize

ErrorBarType (Chart Controls)

Specifies how the upper and lower error values are calculated for the center values of the ErrorBarSeries.

Applicable chart types

Error Bar

Applicable chart elements

Series

Value range

FixedValue, Percentage, StandardDeviation, StandardError

Default value

 

2D or 3D

2D, 3D

This property accepts a formula name with an optional parameter enclosed in parentheses.

  • FixedValue - The error value is a fixed value defined by a required parameter. For example, FixedValue(15).

  • Percentage - Errors are calculated as a percentage of the data point center value with an optional parameter. If a parameter is not specified, a 10% error will be used for upper and lower errors. For example, Percentage(10).

  • StandardDeviation - The error values are determined by applying a standard deviation calculation on the center values in the error bar series with an optional parameter. A supplied parameter (1,2,3, … n) defines the number of standard deviations to use. By default, if a parameter is not provided, a standard deviation of 1 is used. For example, StandardDeviation(3).

  • StandardError - Error values are found by applying standard error calculations on the center values in the error bar series with an optional parameter. The supplied parameter (1,2,3, … n) defines the number of standard errors to use. If none is provided, the default value of 1 is used. For example, StandardError(2).

Show:
© 2014 Microsoft