Skip to main content

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.
See Also