ErrorBars.EndStyle Property (Word)
Returns or sets the end style for the error bars. Read/write Long .
expression A variable that represents an 'ErrorBars' object.
The value of this property can be one of the following XlEndStyleCap constants:
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