ErrorBars Property

The ErrorBars property allows access to line/scatter plot or bar chart vertical and horizontal error bar properties. Returns an AutoErrorBars object. This is a read-only property.

object.ErrorBars

object.ErrorBars =ErrorBars

This example returns the AutoErrorBars object and creates vertical error bars.

'Adds vertical error bars from column C and change

'the properties of the error bars

'Sets the type of vertical bars to From Worksheet

ErrorBars.VertBarType =

'Sets column C as the column that contains the error bars

ErrorBars.VertBarCol = 3

'Sets the direction for the error bars only to

'the positive direction

ErrorBars.VertBarDirection =