Excel.Interfaces.ChartErrorBarsLoadOptions interface

Package:

excel

This object represents the attributes for a chart's error bars.

Remarks

[ API set: ExcelApi 1.9 ]

Properties

$all	Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).
endStyleCap	Specifies if error bars have an end style cap.
format	Specifies the formatting type of the error bars.
include	Specifies which parts of the error bars to include.
type	The type of range marked by the error bars.
visible	Specifies whether the error bars are displayed.

Property Details

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).

TypeScript

$all?: boolean;

Property Value

boolean

endStyleCap

Specifies if error bars have an end style cap.

TypeScript

endStyleCap?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

format

Specifies the formatting type of the error bars.

TypeScript

format?: Excel.Interfaces.ChartErrorBarsFormatLoadOptions;

Property Value

Excel.Interfaces.ChartErrorBarsFormatLoadOptions

Remarks

[ API set: ExcelApi 1.9 ]

include

Specifies which parts of the error bars to include.

TypeScript

include?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

type

The type of range marked by the error bars.

TypeScript

type?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

visible

Specifies whether the error bars are displayed.

TypeScript

visible?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]