Edit

Excel.Interfaces.ChartErrorBarsUpdateData interface

An interface for updating data on the ChartErrorBars object, for use in chartErrorBars.set({ ... }).

Remarks

Used by

Properties

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

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.ChartErrorBarsFormatUpdateData;

Property Value

Remarks

API set: ExcelApi 1.9

include

Specifies which parts of the error bars to include.

include?: Excel.ChartErrorBarsInclude | "Both" | "MinusValues" | "PlusValues";

Property Value

Excel.ChartErrorBarsInclude | "Both" | "MinusValues" | "PlusValues"

Remarks

API set: ExcelApi 1.9

type

The type of range marked by the error bars.

type?: Excel.ChartErrorBarsType | "FixedValue" | "Percent" | "StDev" | "StError" | "Custom";

Property Value

Excel.ChartErrorBarsType | "FixedValue" | "Percent" | "StDev" | "StError" | "Custom"

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