Series Members

A data series in a chart.

Properties

Name	Description
Arguments	Gets or sets the data used as arguments for series points.
AutoGapWidth	Returns or specifies whether to calculate the gap width automatically. Applies to Excel 2016 charts.
AxisGroup	Gets or sets the group type for the axes which are used to plot the series data.
BubbleSize	Gets or sets data used to specify the size of bubbles in a bubble chart.
CustomDataLabels	Provides access to a collection of data labels customized for specific data points or for the entire series.
CustomDataPoints	Provides access to data points with a customized visual appearance.
ErrorBars	Provides access to a collection of error bars for the series.
Explosion	Gets or sets the explosion value for all slices in a pie or doughnut chart series.
Fill	Provides access to fill options for the specified drawing object. Inherited from ShapeFormatBase.
GapWidth	Returns or specifies the distance between data points on the chart.
InvertIfNegative	Gets or sets whether the color (or pattern) of a data point is changed to another (“inverted”) color if the value is negative.
LayoutOptions	Returns series layout options for Excel 2016 charts.
Marker	Obtains specific settings of data markers displayed by series on the line, scatter or radar chart.
Order	Gets the order in which series are plotted.
Outline	Provides access to the options used to format an outline of the specified drawing object. Inherited from ShapeFormatBase.
SeriesName	Gets the name of the series.
SeriesType	Gets the series type.
Shape	Gets or sets the shape used to display data points in the 3D bar or column chart.
Smooth	Gets or sets whether the curve smoothing is turned on for the line or scatter chart.
Trendlines	Provides access to a collection of trendlines for the series.
UseCustomDataLabels	Gets or sets whether to apply custom settings to data labels.
Values	Gets or sets the data used as series point values.
View	Provides access to a view that displays the series.

Methods

Name	Description
BringForward()	Moves the series up one in the chart view plot order.
BringToFront()	Moves the series before other series in the chart view.
ChangeType(ChartType)	Changes the chart type used to plot the series.
Delete()	Deletes the series.
ResetToMatchStyle()	Removes custom formatting of the chart element and applies default formatting based on the chart style. Inherited from ShapeFormat.
SendBackward()	Moves the series down one in the chart view plot order.
SendToBack()	Moves the series behind all other series in the chart view.