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.

Constructors

Section titled "Constructors"

ErrorBars 

new ErrorBars(): ErrorBars

Returns ErrorBars

Properties

Section titled "Properties"

$t

Section titled "$t" 
$t: Type

Accessors

Section titled "Accessors"

chart

Section titled "chart"

Inherited from: ChartObject

Returns the owning chart (read-only)

 
get chart(): WorksheetChart

Returns WorksheetChart

direction

Section titled "direction"

Returns or sets a value which determines the direction in which the error bars extend from the data points.

 
get direction(): ErrorBarDirection

Returns ErrorBarDirection 

set direction(a: ErrorBarDirection): void

Parameters

Returns void

endStyle

Section titled "endStyle"

Returns or sets the end style for the error bars.

 
get endStyle(): EndStyleCap

Returns EndStyleCap 

set endStyle(a: EndStyleCap): void

Parameters

Returns void

errorValueType

Section titled "errorValueType"

Returns or sets a value which determines the units used to evaluate the error.

 
get errorValueType(): ErrorValueType

Returns ErrorValueType 

set errorValueType(a: ErrorValueType): void

Parameters

Returns void

fill

Section titled "fill"

Returns or sets a [[ChartFillBase]] derived object which defines the fill color/gradient for the line.

 
get fill(): ChartFillBase

Returns ChartFillBase 

set fill(a: ChartFillBase): void

Parameters

Returns void

owner

Section titled "owner"

Inherited from: ChartObject

returns this object's owner. (read-only) The owner or null if this object is owned directly by the Chart

 
get owner(): ChartObject

Returns ChartObject

sheet

Section titled "sheet"

Inherited from: ChartObject

The owning sheet (read-only)

 
get sheet(): Sheet

Returns Sheet

value

Section titled "value"

Returns or sets a value which defines the error range.

 
get value(): number

Returns number 

set value(a: number): void

Parameters

  • a: number

Returns void

widthInPoints

Section titled "widthInPoints"

Determines the width of the line, expressed in points.

 
get widthInPoints(): number

Returns number 

set widthInPoints(a: number): void

Parameters

  • a: number

Returns void

workbook

Section titled "workbook"

Inherited from: ChartObject

The owning workbook (read-only)

 
get workbook(): Workbook

Returns Workbook

worksheet

Section titled "worksheet"

Inherited from: ChartObject

The owning worksheet (read-only)

 
get worksheet(): Worksheet

Returns Worksheet