ErrorBars Object

Description

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. There is no singular ErrorBar object; you must turn x error bars or y error bars on or off for all points on a series at once.

Accessors

The ErrorBars property returns the error bars for a chart series. The following example turns on error bars for series one in embedded chart one on the worksheet named "Sheet1" and then sets the end style for the error bars.


Worksheets("sheet1").ChartObjects(1).Activate
ActiveChart.SeriesCollection(1).HasErrorBars = True
ActiveChart.SeriesCollection(1).ErrorBars.EndStyle = xlNoCap

Remarks

The ErrorBar method changes the error bar format and type.

Properties

Application Property, Border Property, Creator Property, EndStyle Property, Name Property, Parent Property.

Methods

ClearFormats Method, Delete Method, Select Method.