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.

Syntax

object.ErrorBars

object.ErrorBars =ErrorBars

Example

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 =

 

Used by: AutoLinePlot object, AutoBarChart