ErrorBar Method

Microsoft Excel Visual Basic

ErrorBar Method

       

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.

Direction  Required XlErrorBarDirection.  The error bar direction.

XlErrorBarDirection can be one of these XlErrorBarDirection constants.
xlX
xlY default

Include  Required XlErrorBarInclude.  The error bar parts to include.

XlErrorBarInclude can be one of these XlErrorBarInclude constants.
xlErrorBarIncludeBoth default
xlErrorBarIncludeNone
xlErrorBarIncludeMinusValues
xlErrorBarIncludePlusValues

Type  Required XlErrorBarType.  The error bar type.

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