ErrorBars.EndStyle Property (Word)

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

Syntax

expression. EndStyle

expression A variable that represents an 'ErrorBars' object.

Remarks

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

  • xlCap

  • xlNoCap

Example

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