ErrorBars.EndStyle property (Word)

Returns or sets the end style for the error bars. Read/write Long.


expression. EndStyle

expression A variable that represents an 'ErrorBars' object.


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

  • xlCap

  • xlNoCap


The following example sets the end style for the error bars for series one of the first chart in the active document. You should run the example on a 2-D line chart that has Y error bars for the first series.

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

See also

ErrorBars Object