Series.ErrorBar (PowerPoint)

Applies error bars to the series.

Syntax : expression.ErrorBar (Direction, Include, Type, Amount, MinusValues)

ActivePresentation.Slides(1).Shapes(1).Chart.FullSeriesCollection(1).ErrorBar Direction:=xlChartX, Include:=xlErrorBarIncludeBoth, Type:=xlErrorBarTypeCustom

Arguments

The following arguments are required:

Direction (XlErrorBarDirection) - One of the enumeration values that specifies the error bar direction.

Possible Values are xlChartX - Bars run parallel to the y-axis for x-axis values, xlChartY - Bars run parallel to the x-axis for y-axis values.

Include (XlErrorBarInclude) - One of the enumeration values that specifies the error bar parts to include.

Possible Values are

xlErrorBarIncludeBoth Both the positive and negative error range.
xlErrorBarIncludeMinusValues Only the negative error range.
xlErrorBarIncludeNone No error bar range.
xlErrorBarIncludePlusValues Only the positive error range.

Type (XlErrorBarType) - One of the enumeration values that specifies the error bar type.

Possible Values are

xlErrorBarTypeCustom The range is set by fixed values or cell values.
xlErrorBarTypeFixedValue Fixed-length error bars.
xlErrorBarTypePercent The percentage of the range to be covered by the error bars.
xlErrorBarTypeStDev Shows the range for a specified number of standard deviations.
xlErrorBarTypeStError Shows the standard error range.

The following arguments are optional

Amount (XlErrorBarType) - The error amount. Used for only the positive error amount when Type is xlErrorBarTypeCustom.

Possible Values are

xlErrorBarTypeCustom The range is set by fixed values or cell values.
xlErrorBarTypeFixedValue Fixed-length error bars.
xlErrorBarTypePercent The percentage of the range to be covered by the error bars.
xlErrorBarTypeStDev Shows the range for a specified number of standard deviations.
xlErrorBarTypeStError Shows the standard error range.

MinusValues (XlErrorBarType) - The negative error amount when Type is xlErrorBarTypeCustom.

Possible Values are

xlErrorBarTypeCustom The range is set by fixed values or cell values.
xlErrorBarTypeFixedValue Fixed-length error bars.
xlErrorBarTypePercent The percentage of the range to be covered by the error bars.
xlErrorBarTypeStDev Shows the range for a specified number of standard deviations.
xlErrorBarTypeStError Shows the standard error range.