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