Series Properties
A data series in a chart.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. |
See Also