Direction Property

Direction property as it applies to the ChErrorBars object.

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

Applies to | ChErrorBars Object | SchemaParameter Object