ErrorBars object (Word)
Represents the error bars on a chart series.
Remarks
Error bars indicate the degree of uncertainty for chart data. Only series in area, bar, column, line, and scatter groups on a 2D chart can have error bars. Only series in scatter groups can have x and y error bars. This object is not a collection. There is no object that represents a single error bar; you either enable x error bars or y error bars for all points in a series or you disable them.
The ErrorBar method changes the error bar format and type.
Example
Use the ErrorBars property to return the ErrorBars object. The following example enables error bars for series one of the first chart in the active document and then sets the end style for the error bars.
With ActiveDocument.InlineShapes(1)
If .HasChart Then
.Chart.SeriesCollection(1).HasErrorBars = True
.Chart.SeriesCollection(1).ErrorBars.EndStyle = xlNoCap
End If
End With
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for