The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

ErrorBars Object

Office 2007
Represents the error bars on a chart series.


Error bars indicate the degree of uncertainty for chart data. Only series in area, bar, column, line, and scatter groups on a 2-D chart can have error bars. Only series in scatter groups can have x and y error bars. This object isn’t a collection. There’s no object that represents a single error bar; you either have x error bars or y error bars turned on for all points in a series or you have them turned off.

The ErrorBar method changes the error bar format and type.


Use the ErrorBars property to return the ErrorBars object. The following example turns on error bars for series one in embedded chart one and then sets the end style for the error bars.

Visual Basic for Applications
ActiveChart.SeriesCollection(1).HasErrorBars = True
ActiveChart.SeriesCollection(1).ErrorBars.EndStyle = xlNoCap

Community Additions