Returns or sets the error-bar direction for the specified error bars. Read/write ChartErrorBarDirectionEnum.
| ChartErrorBarDirectionEnum can be one of these ChartErrorBarDirectionEnum constants. |
| chErrorBarDirectionX |
| chErrorBarDirectionY |
expression.Direction
expression Required. An expression that returns one of the above objects.
Remarks
You can use the chErrorBarDirectionX constant only in xy (scatter), polar, bar, or bubble charts.
Direction property as it applies to the SchemaParameter object.
Returns the Direction parameter for the SchemaRowSource object. Read-only ParameterDirectionEnum (ADO).
expression.Direction
expression Required. An expression that returns one of the above objects.
Example
As it applies to the ChErrorBars object.
This example adds error bars to the specified chart and sets the error-bar direction. Charts(0) must refer to an xy (scatter), polar, bar, or bubble chart.
Sub AddErrorBars()
Dim ebErrorBars
Dim chConstants
Set chConstants = Chartspace1.Constants
' Add error bars to the first series in the chart.
Set ebErrorBars = ChartSpace1.Charts(0).SeriesCollection(0).ErrorBarsCollection.Add
' Set the direction of the error bars.
ebErrorBars.Direction = chConstants.chErrorBarDirectionX
End Sub