ErrorBar Method

  • Article

Applies error bars to the specified series. Variant.

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

XlErrorBarDirection can be one of these XlErrorBarDirection constants.
xlX Can only be used with scatter charts.
xlYdefault.
XlErrorBarInclude can be one of these XlErrorBarInclude constants.
xlErrorBarIncludeBothdefault.
xlErrorBarIncludeMinusValues
xlErrorBarIncludeNone
xlErrorBarIncludePlusValues
XlErrorBarType can be one of these XlErrorBarType constants.
xlErrorBarTypeCustom
xlErrorBarTypeFixedValue
xlErrorBarTypePercent
xlErrorBarTypeStDev
xlErrorBarTypeStError

Example

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

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

See Also