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