Series Members
In This Article
#Properties
Name | Description |
---|---|
Arguments | Gets or sets the data used as arguments for series points. |
Auto |
Returns or specifies whether to calculate the gap width automatically. Applies to Excel 2016 charts. |
Axis |
Gets or sets the group type for the axes which are used to plot the series data. |
Bubble |
Gets or sets data used to specify the size of bubbles in a bubble chart. |
Custom |
Provides access to a collection of data labels customized for specific data points or for the entire series. |
Custom |
Provides access to data points with a customized visual appearance. |
Error |
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 Shape |
Gap |
Returns or specifies the distance between data points on the chart. |
Invert |
Gets or sets whether the color (or pattern) of a data point is changed to another (“inverted”) color if the value is negative. |
Layout |
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 Shape |
Series |
Gets the name of the series. |
Series |
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. |
Use |
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 |
---|---|
Bring |
Moves the series up one in the chart view plot order. |
Bring |
Moves the series before other series in the chart view. |
Change |
Changes the chart type used to plot the series. |
Delete() | Deletes the series. |
Reset |
Removes custom formatting of the chart element and applies default formatting based on the chart style.
Inherited from Shape |
Send |
Moves the series down one in the chart view plot order. |
Send |
Moves the series behind all other series in the chart view. |
See Also