Edit

Excel.Interfaces.ChartErrorBarsLoadOptions interface

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

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).

$all?: boolean;

Property Value

boolean

endStyleCap

Specifies if error bars have an end style cap.

endStyleCap?: boolean;

Property Value

boolean

Remarks

API set: ExcelApi 1.9

format

Specifies the formatting type of the error bars.

format?: Excel.Interfaces.ChartErrorBarsFormatLoadOptions;

Property Value

Remarks

API set: ExcelApi 1.9

include

Specifies which parts of the error bars to include.

include?: boolean;

Property Value

boolean

Remarks

API set: ExcelApi 1.9

type

The type of range marked by the error bars.

type?: boolean;

Property Value

boolean

Remarks

API set: ExcelApi 1.9

visible

Specifies whether the error bars are displayed.

visible?: boolean;

Property Value

boolean

Remarks

API set: ExcelApi 1.9