ErrorBar Method [Excel 2003 VBA Language Reference]

  • Article

Applies error bars to the series. Variant.

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

expression Required. An expression that returns one of the objects in the Applies To list.

XlErrorBarDirection

XlErrorBarDirection can be one of these XlErrorBarDirection constants.
xlX
xlYdefault

XlErrorBarInclude

XlErrorBarInclude can be one of these XlErrorBarInclude constants.
xlErrorBarIncludeBothdefault
xlErrorBarIncludeNone
xlErrorBarIncludeMinusValues
xlErrorBarIncludePlusValues

XlErrorBarType

XlErrorBarType can be one of these XlErrorBarType constants.
xlErrorBarTypeCustom
xlErrorBarTypePercent
xlErrorBarTypeStError
xlErrorBarTypeFixedValue
xlErrorBarTypeStDev

Amount  Optional Variant. The error amount. Used for only the positive error amount when Type is xlErrorBarTypeCustom.

MinusValues  Optional Variant. The negative error amount when Type is xlErrorBarTypeCustom.

Example

This example applies standard error bars in the Y direction for series one in Chart1. The error bars are applied in the positive and negative directions. The example should be run on a 2-D line chart.

Charts("Chart1").SeriesCollection(1).ErrorBar _
    Direction:=xlY, Include:=xlErrorBarIncludeBoth, _
    Type:=xlErrorBarTypeStError

Applies to | Series Object

See Also | ErrorBars Property | HasErrorBars Property