Class ErrorBars (Word VBA)

The class ErrorBars represents the error bars on a chart series.

Set

To use a ErrorBars class variable it first needs to be instantiated, for example

Dim ebs as ErrorBars
Set ebs = ActiveDocument.Background.Chart.FullSeriesCollection(1).ErrorBars

ErrorBars class variables can be set using the Series.ErrorBars procedure.

Border

Returns the border of the object.

Dim cbrBorder As ChartBorder
Set cbrBorder = ActiveDocument.Background.Chart.FullSeriesCollection(1).ErrorBars.Border

ClearFormats

Clears the formatting of the object.

ActiveDocument.Background.Chart.FullSeriesCollection(1).ErrorBars.ClearFormats

Delete

Deletes the object.

ActiveDocument.Background.Chart.FullSeriesCollection(1).ErrorBars.Delete

EndStyle

Returns or sets the end style for the error bars.

Possible Values are xlCap - Caps are applied, xlNoCap - No caps are applied.

The value of this property can be one of the following XlEndStyleCap constants:

With ActiveDocument.InlineShapes(1) 
 If .HasChart Then 
 .Chart.SeriesCollection(1).ErrorBars.EndStyle = xlCap 
 End If 
End With

Format

Returns the line, fill, and effect formatting for the object.

Dim cftFormatted As ChartFormat
Set cftFormatted = ActiveDocument.Background.Chart.FullSeriesCollection(1).ErrorBars.Format

GetProperty

Syntax : expression.GetProperty (ID)

Name

Returns the name of the object.

Dim strName As String
strName = ActiveDocument.Background.Chart.FullSeriesCollection(1).ErrorBars.Name

Parent

Returns the parent for the specified object. Read-only object.

Dim objParent As Object
Set objParent = ActiveDocument.Background.Chart.FullSeriesCollection(1).ErrorBars.Parent

Select

Selects the object.

ActiveDocument.Background.Chart.FullSeriesCollection(1).ErrorBars.Select

SetProperty

Syntax : expression.SetProperty (ID, Value)

Dim strID As String: strID =  
ActiveDocument.Background.Chart.FullSeriesCollection(1).ErrorBars.SetProperty ID:=strID, Value:=

Arguments

The following arguments are required:

ID - String

Value