Class Series (PowerPoint VBA)

The class Series represents a series in a chart.

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

Dim srs as Series
Set srs = ActiveWindow.RangeFromPoint.Chart.FullSeriesCollection(Index:=1)

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

Methods

ApplyDataLabels - Applies data labels to a series.

ClearFormats - Clears the formatting of the object.

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

DataLabels - Returns an datalabel that represents either a single data label (a DataLabel datalabel) 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.

GetProperty -

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

Points - Returns a collection of all the points in the series.

Select - Selects the object.

SetProperty -

Trendlines - Returns a collection of all the trendlines for the series.

Properties

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 the type of axis group.

BarShape returns or sets the shape used for a single series in a 3D bar or column chart.

BubbleSizes returns or sets a string that refers to the worksheet cells that contain the x-value, y-value, and size data for the bubble chart.

ChartType returns or sets the chart type.

ErrorBars returns the error bars for the series.

Explosion returns or sets the explosion value for a pie-chart or doughnut-chart slice.

Format returns the line, fill, and effect formatting for the object.

Formula returns or sets 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

GeoProjectionType

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.

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 Word inverts the pattern in the object when it corresponds to a negative number.

IsFiltered returns or sets a Boolean that determines whether the specified chart series is filtered out from the chart.

LeaderLines returns the leader lines for the series.

MarkerBackgroundColor sets the marker background color as an RGB value or returns the corresponding color index value.

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.

MarkerForegroundColor sets the marker foreground color as an RGB value or returns the corresponding color index value.

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.

MarkerSize returns or sets the data-marker size, in points.

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 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 a value that specifies how 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; otherwise, 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

Shadow returns or sets a value that indicates whether the object has a shadow.

Smooth true if curve smoothing is enabled for the line chart or scatter chart.

Type returns or sets the series type.

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

ValueSortOrder

XValues returns or sets an array of x values for a chart series.

ChartFormat - Provides access to the OfficeArt formatting for chart elements.

DataLabel - Represents the data label on a chart point or trendline.

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

ErrorBars - Represents the error bars on a chart series.

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

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