Applies To
Series Object.
Description
Applies error bars to the series.
Syntax
object.ErrorBar(direction, include, type, amount, minusValues)
object
Required. The Series object.
direction
Optional. Specifies the error bar direction (can be xlX or xlY; X is only available for scatter charts). If omitted, error bars are applied in the Y direction.
include
Optional. Specifies the error bar parts to include (one of xlPlusValues, xlMinusValues, xlNone, or xlBoth). If omitted, both error bars are included.
type
Optional. Specifies the error bar type (one of xlFixedValue, xlPercent, xlStDev, xlStError, or xlCustom).
amount
Optional. The error amount. Used for only the positive error amount when type = xlCustom.
minusValues
Optional. The negative error amount when type = xlCustom.
See Also
ErrorBars Property, HasErrorBars Property.
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:=xlBoth, type:=xlStError