Series.ErrorBar Method
Applies error bars to the series. Variant.
Syntax
expression.ErrorBar(Direction, Include, Type, Amount, MinusValues)
expression A variable that represents a Series object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Direction | Required | XlErrorBarDirection | The error bar direction. |
| Include | Required | XlErrorBarInclude | The error bar parts to include. |
| Type | Required | XlErrorBarType | The error bar type. |
| 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. |
Return Value
Variant
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.
| Visual Basic for Applications |
|---|
|