Excel.Interfaces.ChartSeriesCollectionLoadOptions interface
Represents a collection of chart series.
Remarks
Properties
| $all | Specifying |
| axis |
For EACH ITEM in the collection: Specifies the group for the specified series. |
| bin |
For EACH ITEM in the collection: Encapsulates the bin options for histogram charts and pareto charts. |
| boxwhisker |
For EACH ITEM in the collection: Encapsulates the options for the box and whisker charts. |
| bubble |
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. |
| chart |
For EACH ITEM in the collection: Represents the chart type of a series. See |
| data |
For EACH ITEM in the collection: Represents a collection of all data labels in the series. |
| doughnut |
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 |
| explosion | 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). |
| filtered | For EACH ITEM in the collection: Specifies if the series is filtered. Not applicable for surface charts. |
| first |
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. |
| format | For EACH ITEM in the collection: Represents the formatting of a chart series, which includes fill and line formatting. |
| gap |
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. |
| gradient |
For EACH ITEM in the collection: Specifies the color for maximum value of a region map chart series. |
| gradient |
For EACH ITEM in the collection: Specifies the type for maximum value of a region map chart series. |
| gradient |
For EACH ITEM in the collection: Specifies the maximum value of a region map chart series. |
| gradient |
For EACH ITEM in the collection: Specifies the color for the midpoint value of a region map chart series. |
| gradient |
For EACH ITEM in the collection: Specifies the type for the midpoint value of a region map chart series. |
| gradient |
For EACH ITEM in the collection: Specifies the midpoint value of a region map chart series. |
| gradient |
For EACH ITEM in the collection: Specifies the color for the minimum value of a region map chart series. |
| gradient |
For EACH ITEM in the collection: Specifies the type for the minimum value of a region map chart series. |
| gradient |
For EACH ITEM in the collection: Specifies the minimum value of a region map chart series. |
| gradient |
For EACH ITEM in the collection: Specifies the series gradient style of a region map chart. |
| has |
For EACH ITEM in the collection: Specifies if the series has data labels. |
| invert |
For EACH ITEM in the collection: Specifies the fill color for negative data points in a series. |
| invert |
For EACH ITEM in the collection: True if Excel inverts the pattern in the item when it corresponds to a negative number. |
| map |
For EACH ITEM in the collection: Encapsulates the options for a region map chart. |
| marker |
For EACH ITEM in the collection: Specifies the marker background color of a chart series. |
| marker |
For EACH ITEM in the collection: Specifies the marker foreground color of a chart series. |
| marker |
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. |
| marker |
For EACH ITEM in the collection: Specifies the marker style of a chart series. See |
| name | 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. |
| overlap | 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. |
| parent |
For EACH ITEM in the collection: Specifies the series parent label strategy area for a treemap chart. |
| plot |
For EACH ITEM in the collection: Specifies the plot order of a chart series within the chart group. |
| points | For EACH ITEM in the collection: Returns a collection of all points in the series. |
| second |
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. |
| show |
For EACH ITEM in the collection: Specifies whether connector lines are shown in waterfall charts. |
| show |
For EACH ITEM in the collection: Specifies whether leader lines are displayed for each data label in the series. |
| show |
For EACH ITEM in the collection: Specifies if the series has a shadow. |
| smooth | For EACH ITEM in the collection: Specifies if the series is smooth. Only applicable to line and scatter charts. |
| split |
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. |
| split |
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. |
| vary |
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. |
| x |
For EACH ITEM in the collection: Represents the error bar object of a chart series. |
| y |
For EACH ITEM in the collection: Represents the error bar object of a chart series. |
Property Details
$all
Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: Range.format.fill.color).
$all?: boolean;Property Value
boolean
axisGroup
For EACH ITEM in the collection: Specifies the group for the specified series.
axisGroup?: boolean;Property Value
boolean
Remarks
binOptions
For EACH ITEM in the collection: Encapsulates the bin options for histogram charts and pareto charts.
binOptions?: Excel.Interfaces.ChartBinOptionsLoadOptions;Property Value
Remarks
boxwhiskerOptions
For EACH ITEM in the collection: Encapsulates the options for the box and whisker charts.
boxwhiskerOptions?: Excel.Interfaces.ChartBoxwhiskerOptionsLoadOptions;Property Value
Remarks
bubbleScale
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
boolean
Remarks
chartType
For EACH ITEM in the collection: Represents the chart type of a series. See Excel.ChartType for details.
chartType?: boolean;Property Value
boolean
Remarks
dataLabels
For EACH ITEM in the collection: Represents a collection of all data labels in the series.
dataLabels?: Excel.Interfaces.ChartDataLabelsLoadOptions;Property Value
Remarks
doughnutHoleSize
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
boolean
Remarks
explosion
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
boolean
Remarks
filtered
For EACH ITEM in the collection: Specifies if the series is filtered. Not applicable for surface charts.
filtered?: boolean;Property Value
boolean
Remarks
firstSliceAngle
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
boolean
Remarks
format
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
gapWidth
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
boolean
Remarks
gradientMaximumColor
For EACH ITEM in the collection: Specifies the color for maximum value of a region map chart series.
gradientMaximumColor?: boolean;Property Value
boolean
Remarks
gradientMaximumType
For EACH ITEM in the collection: Specifies the type for maximum value of a region map chart series.
gradientMaximumType?: boolean;Property Value
boolean
Remarks
gradientMaximumValue
For EACH ITEM in the collection: Specifies the maximum value of a region map chart series.
gradientMaximumValue?: boolean;Property Value
boolean
Remarks
gradientMidpointColor
For EACH ITEM in the collection: Specifies the color for the midpoint value of a region map chart series.
gradientMidpointColor?: boolean;Property Value
boolean
Remarks
gradientMidpointType
For EACH ITEM in the collection: Specifies the type for the midpoint value of a region map chart series.
gradientMidpointType?: boolean;Property Value
boolean
Remarks
gradientMidpointValue
For EACH ITEM in the collection: Specifies the midpoint value of a region map chart series.
gradientMidpointValue?: boolean;Property Value
boolean
Remarks
gradientMinimumColor
For EACH ITEM in the collection: Specifies the color for the minimum value of a region map chart series.
gradientMinimumColor?: boolean;Property Value
boolean
Remarks
gradientMinimumType
For EACH ITEM in the collection: Specifies the type for the minimum value of a region map chart series.
gradientMinimumType?: boolean;Property Value
boolean
Remarks
gradientMinimumValue
For EACH ITEM in the collection: Specifies the minimum value of a region map chart series.
gradientMinimumValue?: boolean;Property Value
boolean
Remarks
gradientStyle
For EACH ITEM in the collection: Specifies the series gradient style of a region map chart.
gradientStyle?: boolean;Property Value
boolean
Remarks
hasDataLabels
For EACH ITEM in the collection: Specifies if the series has data labels.
hasDataLabels?: boolean;Property Value
boolean
Remarks
invertColor
For EACH ITEM in the collection: Specifies the fill color for negative data points in a series.
invertColor?: boolean;Property Value
boolean
Remarks
invertIfNegative
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
boolean
Remarks
mapOptions
For EACH ITEM in the collection: Encapsulates the options for a region map chart.
mapOptions?: Excel.Interfaces.ChartMapOptionsLoadOptions;Property Value
Remarks
markerBackgroundColor
For EACH ITEM in the collection: Specifies the marker background color of a chart series.
markerBackgroundColor?: boolean;Property Value
boolean
Remarks
markerForegroundColor
For EACH ITEM in the collection: Specifies the marker foreground color of a chart series.
markerForegroundColor?: boolean;Property Value
boolean
Remarks
markerSize
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
boolean
Remarks
markerStyle
For EACH ITEM in the collection: Specifies the marker style of a chart series. See Excel.ChartMarkerStyle for details.
markerStyle?: boolean;Property Value
boolean
Remarks
name
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
boolean
Remarks
overlap
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
boolean
Remarks
parentLabelStrategy
For EACH ITEM in the collection: Specifies the series parent label strategy area for a treemap chart.
parentLabelStrategy?: boolean;Property Value
boolean
Remarks
plotOrder
For EACH ITEM in the collection: Specifies the plot order of a chart series within the chart group.
plotOrder?: boolean;Property Value
boolean
Remarks
points
For EACH ITEM in the collection: Returns a collection of all points in the series.
points?: Excel.Interfaces.ChartPointsCollectionLoadOptions;Property Value
Remarks
secondPlotSize
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
boolean
Remarks
showConnectorLines
For EACH ITEM in the collection: Specifies whether connector lines are shown in waterfall charts.
showConnectorLines?: boolean;Property Value
boolean
Remarks
showLeaderLines
For EACH ITEM in the collection: Specifies whether leader lines are displayed for each data label in the series.
showLeaderLines?: boolean;Property Value
boolean
Remarks
showShadow
For EACH ITEM in the collection: Specifies if the series has a shadow.
showShadow?: boolean;Property Value
boolean
Remarks
smooth
For EACH ITEM in the collection: Specifies if the series is smooth. Only applicable to line and scatter charts.
smooth?: boolean;Property Value
boolean
Remarks
splitType
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
boolean
Remarks
splitValue
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
boolean
Remarks
varyByCategories
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
boolean
Remarks
xErrorBars
For EACH ITEM in the collection: Represents the error bar object of a chart series.
xErrorBars?: Excel.Interfaces.ChartErrorBarsLoadOptions;Property Value
Remarks
yErrorBars
For EACH ITEM in the collection: Represents the error bar object of a chart series.
yErrorBars?: Excel.Interfaces.ChartErrorBarsLoadOptions;Property Value
Remarks
Office Add-ins
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for