Direction Property

Microsoft Office Web Components Object Model

Show All

Direction Property

       

Direction property as it applies to the ChErrorBars object.

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