Description
A Series object represents a single data series in a chart. To return a Series
object, use one of the SeriesCollection.CreateSeries methods.
Properties
Name |
Description |
---|---|
If the chart contains two X or Y axes, AxisType sets or returns whether the series is associated with the primary or secondary axis. | |
Sets or returns a range formula that determines the size of the bubbles in a bubble chart. Bubble size is a way to illustrate a z-dimension on a chart. Every element in the series should have its own bubble that will be plotted on the graph. To give the bubble a numeric size, this method requires you to select a range of numeric values. The output size of the bubbles will be a ratio between the smallest and largest bubble size values. For example, if the bubble sizes are 20, 20, and 20, all the bubbles will be the same size. However, if the values are 100, 2, and 1, the first bubble will be very large, the third extremely small, and the second two times as large as the third. |
|
Sets or returns the ChartType the series is displayed as. |
|
Returns a SeriesDataLabel object for formatting series data labels. | |
Returns a DataPointMarker object representing the data markers of a line, radar, or scatter series. | |
Returns an ErrorBar object representing the horizontal error bars for the series. | |
Returns an ErrorBar object representing the vertical error bars for the series. | |
Sets or returns whether the series will be displayed with a shadow effect. | |
Sets or returns returns whether data points in a line, scatter, or radar chart are connected by smoothed lines, or whether the data points are connected by straight lines. | |
Returns a ChartInterior object, representing the area of the data series. | |
Sets or returns the Font object for the series legend entry. | |
Returns a ChartLine object representing either the border around the series - for most chart types - or the series line itself, for line charts. | |
Sets or returns the name of the series. See also Series.NameFormula. | |
Sets or returns the formula containing the name of the series. See also Series.Name. | |
Sets or returns the range of cells containing the x-values of a scatter or bubble chart data series. | |
Returns a SettingsBarColumn object representing the series properties unique to bar and column charts. | |
Returns a SettingsLineAreaScatter object representing the series properties unique to line, area, and scatter charts. | |
Returns a SettingsPieDoughnut object representing the series properties unique to pie and doughnut charts. | |
Sets or returns whether the legend entry for this series will be shown. | |
Returns the Trendlines collection for the series. A trendline graphically shows trends in a data series, such as increased sales over a period of months. | |
Sets or returns the range of cells containing the values of a chart data series. | |
Sets or returns whether colors will be different for each data point in the series. |
Indexers
Name |
Description |
---|---|
Returns the DataPoint object at the specified 0-based index. |
Methods
Name |
Description |
---|---|
Changes the ChartType and AxisType of the series at the same time. |