Excel.Interfaces.ChartSeriesLoadOptions interface

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

Represents the chart type of a series. See Excel.ChartType for details.

chartType?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Represents the doughnut hole size of a chart series. Only valid on doughnut and doughnut exploded charts. Throws an InvalidArgument error on invalid charts.

doughnutHoleSize?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Specifies if the series is filtered. Not applicable for surface charts.

filtered?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Represents the formatting of a chart series, which includes fill and line formatting.

format?: Excel.Interfaces.ChartSeriesFormatLoadOptions;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

Represents the gap width of a chart series. Only valid on bar and column charts, as well as specific classes of line and pie charts. Throws an invalid argument exception on invalid charts.

gapWidth?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Specifies if the series has data labels.

hasDataLabels?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Specifies the marker background color of a chart series.

markerBackgroundColor?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Specifies the marker foreground color of a chart series.

markerForegroundColor?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Specifies the marker size of a chart series. The supported size range is 2 to 72. This method returns an InvalidArgument error if it's set with a size outside of the supported range.

markerSize?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Specifies the marker style of a chart series. See Excel.ChartMarkerStyle for details.

markerStyle?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Specifies the name of a series in a chart. The name's length should not be greater than 255 characters.

name?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

Specifies the plot order of a chart series within the chart group.

plotOrder?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Returns a collection of all points in the series.

points?: Excel.Interfaces.ChartPointsCollectionLoadOptions;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

Specifies if the series has a shadow.

showShadow?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Specifies if the series is smooth. Only applicable to line and scatter charts.

smooth?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]