Excel.Interfaces.ChartSeriesCollectionLoadOptions 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

For EACH ITEM in the collection: Specifies the group for the specified series.

axisGroup?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.8 ]

For EACH ITEM in the collection: Encapsulates the bin options for histogram charts and pareto charts.

binOptions?: Excel.Interfaces.ChartBinOptionsLoadOptions;

Property Value

Remarks

[ API set: ExcelApi 1.9 ]

For EACH ITEM in the collection: Encapsulates the options for the box and whisker charts.

boxwhiskerOptions?: Excel.Interfaces.ChartBoxwhiskerOptionsLoadOptions;

Property Value

Remarks

[ API set: ExcelApi 1.9 ]

For EACH ITEM in the collection: This can be an integer value from 0 (zero) to 300, representing the percentage of the default size. This property only applies to bubble charts.

bubbleScale?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.9 ]

For EACH ITEM in the collection: Represents the chart type of a series. See Excel.ChartType for details.

chartType?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

For EACH ITEM in the collection: Represents a collection of all data labels in the series.

dataLabels?: Excel.Interfaces.ChartDataLabelsLoadOptions;

Property Value

Remarks

[ API set: ExcelApi 1.8 ]

For EACH ITEM in the collection: 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 ]

For EACH ITEM in the collection: Specifies the explosion value for a pie-chart or doughnut-chart slice. Returns 0 (zero) if there's no explosion (the tip of the slice is in the center of the pie).

explosion?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.8 ]

For EACH ITEM in the collection: Specifies if the series is filtered. Not applicable for surface charts.

filtered?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

For EACH ITEM in the collection: Specifies the angle of the first pie-chart or doughnut-chart slice, in degrees (clockwise from vertical). Applies only to pie, 3-D pie, and doughnut charts. Can be a value from 0 through 360.

firstSliceAngle?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.8 ]

For EACH ITEM in the collection: 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 ]

For EACH ITEM in the collection: 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 ]

For EACH ITEM in the collection: Specifies the color for maximum value of a region map chart series.

gradientMaximumColor?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.9 ]

For EACH ITEM in the collection: Specifies the type for maximum value of a region map chart series.

gradientMaximumType?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.9 ]

For EACH ITEM in the collection: Specifies the maximum value of a region map chart series.

gradientMaximumValue?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.9 ]

For EACH ITEM in the collection: Specifies the color for the midpoint value of a region map chart series.

gradientMidpointColor?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.9 ]

For EACH ITEM in the collection: Specifies the type for the midpoint value of a region map chart series.

gradientMidpointType?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.9 ]

For EACH ITEM in the collection: Specifies the midpoint value of a region map chart series.

gradientMidpointValue?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.9 ]

For EACH ITEM in the collection: Specifies the color for the minimum value of a region map chart series.

gradientMinimumColor?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.9 ]

For EACH ITEM in the collection: Specifies the type for the minimum value of a region map chart series.

gradientMinimumType?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.9 ]

For EACH ITEM in the collection: Specifies the minimum value of a region map chart series.

gradientMinimumValue?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.9 ]

For EACH ITEM in the collection: Specifies the series gradient style of a region map chart.

gradientStyle?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.9 ]

For EACH ITEM in the collection: Specifies if the series has data labels.

hasDataLabels?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

For EACH ITEM in the collection: Specifies the fill color for negative data points in a series.

invertColor?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.9 ]

For EACH ITEM in the collection: True if Excel inverts the pattern in the item when it corresponds to a negative number.

invertIfNegative?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.8 ]

For EACH ITEM in the collection: Encapsulates the options for a region map chart.

mapOptions?: Excel.Interfaces.ChartMapOptionsLoadOptions;

Property Value

Remarks

[ API set: ExcelApi 1.9 ]

For EACH ITEM in the collection: Specifies the marker background color of a chart series.

markerBackgroundColor?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

For EACH ITEM in the collection: Specifies the marker foreground color of a chart series.

markerForegroundColor?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

For EACH ITEM in the collection: 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 ]

For EACH ITEM in the collection: Specifies the marker style of a chart series. See Excel.ChartMarkerStyle for details.

markerStyle?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

For EACH ITEM in the collection: 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 ]

For EACH ITEM in the collection: Specifies how bars and columns are positioned. Can be a value between -100 and 100. Applies only to 2-D bar and 2-D column charts.

overlap?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.8 ]

For EACH ITEM in the collection: Specifies the series parent label strategy area for a treemap chart.

parentLabelStrategy?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.9 ]

For EACH ITEM in the collection: Specifies the plot order of a chart series within the chart group.

plotOrder?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

For EACH ITEM in the collection: Returns a collection of all points in the series.

points?: Excel.Interfaces.ChartPointsCollectionLoadOptions;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

For EACH ITEM in the collection: Specifies the size of the secondary section of either a pie-of-pie chart or a bar-of-pie chart, as a percentage of the size of the primary pie. Can be a value from 5 to 200.

secondPlotSize?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.8 ]

For EACH ITEM in the collection: Specifies whether connector lines are shown in waterfall charts.

showConnectorLines?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.9 ]

For EACH ITEM in the collection: Specifies whether leader lines are displayed for each data label in the series.

showLeaderLines?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.9 ]

For EACH ITEM in the collection: Specifies if the series has a shadow.

showShadow?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

For EACH ITEM in the collection: Specifies if the series is smooth. Only applicable to line and scatter charts.

smooth?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

For EACH ITEM in the collection: Specifies the way the two sections of either a pie-of-pie chart or a bar-of-pie chart are split.

splitType?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.8 ]

For EACH ITEM in the collection: Specifies the threshold value that separates two sections of either a pie-of-pie chart or a bar-of-pie chart.

splitValue?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.9 ]

For EACH ITEM in the collection: True if Excel assigns a different color or pattern to each data marker. The chart must contain only one series.

varyByCategories?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.8 ]

For EACH ITEM in the collection: Represents the error bar object of a chart series.

xErrorBars?: Excel.Interfaces.ChartErrorBarsLoadOptions;

Property Value

Remarks

[ API set: ExcelApi 1.9 ]

For EACH ITEM in the collection: Represents the error bar object of a chart series.

yErrorBars?: Excel.Interfaces.ChartErrorBarsLoadOptions;

Property Value

Remarks

[ API set: ExcelApi 1.9 ]