Class Series (Excel VBA)

The class Series represents a series in a chart.

Member in collection

Item

To use a Series class variable it first needs to be instantiated, for example

Dim srs as Series
Set srs = ActiveChart.FullSeriesCollection(Index:=1)

The following procedures can be used to set variables of type Series: FullSeriesCollection.Item, SeriesCollection.Add, SeriesCollection.Item and SeriesCollection.NewSeries.

For Each

Here is an example of processing the Series items in a collection.

Dim srsFullSeriesCollection As Series
For Each srsFullSeriesCollection In ActiveChart.FullSeriesCollection()
	
Next srsFullSeriesCollection

FullSeriesCollection.Item - Returns a single object from the FullSeriesCollection object.

ApplyDataLabels - Applies data labels to a series.

ClearFormats - Clears the formatting of the object.

Copy - If the series has a picture fill, this method copies the picture to the Clipboard.

DataLabels - Returns an datalabels that represents either a single data label (a DataLabel datalabels) or a collection of all the data labels for the series (a DataLabels collection).

Delete - Deletes the object.

ErrorBar - Applies error bars to the series.

Paste - Pastes a picture from the Clipboard as the marker on the selected series.

Points - Returns an points that represents a single point (a Point points) or a collection of all the points (a Points collection) in the series. Read-only.

Select - Selects the object.

Trendlines - Returns an trendlines that represents a single trendline (a Trendline trendlines) or a collection of all the trendlines (a Trendlines collection) for the series.

SeriesCollection.Add - Adds one or more new series to the SeriesCollection collection.

SeriesCollection.Extend - Adds new data points to an existing series collection.

SeriesCollection.Item - Returns a single object from a collection.

SeriesCollection.NewSeries - Creates a new series. Returns a Series object that represents the new series.

SeriesCollection.Paste - Pastes data from the Clipboard into the specified series collection.

Properties

FullSeriesCollection.Count returns a Long value that represents the number of Series objects in the FullSeriesCollection object.

ApplyPictToEnd true if a picture is applied to the end of the point or all points in the series.

ApplyPictToFront true if a picture is applied to the front of the point or all points in the series.

ApplyPictToSides true if a picture is applied to the sides of the point or all points in the series.

AxisGroup returns or sets the group for the specified series.

BarShape returns or sets the shape used with the 3D bar or column chart.

BubbleSizes returns or sets a string that refers to the worksheet cells containing the x-value, y-value, and size data for the bubble chart. When you return the cell reference, it will return a string describing the cells in A1-style notation. To set the size data for the bubble chart, you must use R1C1-style notation. Applies only to bubble charts.

ChartType returns or sets the chart type.

ErrorBars returns an ErrorBars object that represents the error bars for the series.

Explosion returns or sets the explosion value for a pie-chart or doughnut-chart slice. Returns 0 (zero) if there's no explosion (the tip of the slice is in the center of the pie).

Format returns the ChartFormat object.

Formula returns or sets a String value that represents the object's formula in A1-style notation and in the language of the macro.

FormulaLocal returns or sets the formula for the object, using A1-style references in the language of the user.

FormulaR1C1 returns or sets the formula for the object, using R1C1-style notation in the language of the macro.

FormulaR1C1Local returns or sets the formula for the object, using R1C1-style notation in the language of the user.

GeoMappingLevel specifies the geography mapping level for the specified series within the chart group.

GeoProjectionType specifies the geography projection type for the specified series within the chart group.

Has3DEffect true if the series has a three-dimensional appearance.

HasDataLabels true if the series has data labels.

HasErrorBars true if the series has error bars. This property isn't available for 3D charts.

HasLeaderLines true if the series has leader lines.

InvertColor returns or sets the fill color for negative data points in a series.

InvertColorIndex returns or sets the fill color for negative data points in a series.

InvertIfNegative true if Microsoft Excel inverts the pattern in the item when it corresponds to a negative number.

IsFiltered this setting controls whether the series has been filtered out from the chart. The default value is False.

LeaderLines returns a LeaderLines object that represents the leader lines for the series.

MarkerBackgroundColor sets the marker background color as an RGB value or returns the corresponding color index value. Applies only to line, scatter, and radar charts.

MarkerBackgroundColorIndex returns or sets the marker background color as an index into the current color palette, or as one of the following XlColorIndex constants: xlColorIndexAutomatic or xlColorIndexNone. Applies only to line, scatter, and radar charts.

MarkerForegroundColor sets the marker foreground color as an RGB value or returns the corresponding color index value. Applies only to line, scatter, and radar charts.

MarkerForegroundColorIndex returns or sets the marker foreground color as an index into the current color palette, or as one of the following XlColorIndex constants: xlColorIndexAutomatic or xlColorIndexNone. Applies only to line, scatter, and radar charts.

MarkerSize returns or sets the data-marker size, in points. Can be a value from 2 through 72.

MarkerStyle returns or sets the marker style for a point or series in a line chart, scatter chart, or radar chart.

Name returns or sets a String value representing the name of the object.

ParentDataLabelOption specifies the parent data label option (banner, overlapping, or none) for the specified series within the chart group.

PictureType returns or sets an XlChartPictureType value that represents the way pictures are displayed on a column or bar picture chart.

PictureUnit2 returns or sets the unit for each picture on the chart if the PictureType property is set to xlStackScale (if not, this property is ignored).

PlotColorIndex returns an index value that is used internally to associate series formatting with chart elements.

PlotOrder returns or sets the plot order for the selected series within the chart group.

QuartileCalculationInclusiveMedian true if the series uses an inclusive median quartile calculation method.

RegionLabelOption

SeriesColorGradientStyle

SeriesColorMaxGradientStop

SeriesColorMidGradientStop

SeriesColorMinGradientStop

Shadow returns or sets a Boolean value that determines if the object has a shadow.

Smooth true if curve smoothing is turned on for the line chart or scatter chart. Applies only to line and scatter charts.

Type returns or sets a Long value that represents the series type.

Values returns or sets a value that represents a collection of all the values in the series.

ValueSortOrder

XValues returns or sets an array of x values for a chart series. The XValues property can be set to a range on a worksheet or to an array of values, but it cannot be a combination of both.

SeriesCollection.Count returns a Long value that represents the number of objects in the collection.

ChartFormat - Provides access to the Office Art formatting for chart elements.

ChartSeriesGradientStopData -

DataLabels - A collection of all the DataLabel objects for the specified series.

ErrorBars - Represents the error bars in a chart series.

LeaderLines - Represents leader lines on a chart. Leader lines connect data labels to data points.

Points - A collection of all the Point objects in the specified series in a chart.

Trendlines - A collection of all the Trendline objects for the specified series.