This documentation is archived and is not being maintained.

Series Members (Word)

Office 2010

Represents a series in a chart.

Name

Description

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 object that represents either a single data label (a DataLabel object) 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 a collection of all the points in the series.

Select

Selects the object.

Trendlines

Returns a collection of all the trendlines for the series.

Name

Description

Application

When used without an object qualifier, returns an Application object that represents the Microsoft Word application. When used with an object qualifier, returns an Application object that represents the creator of the specified object (you can use this property with an Automation object to return the application of that object). Read-only.

ApplyPictToEnd

True if a picture is applied to the end of the point or all points in the series. Read/write Boolean.

ApplyPictToFront

True if a picture is applied to the front of the point or all points in the series. Read/write Boolean.

ApplyPictToSides

True if a picture is applied to the sides of the point or all points in the series. Read/write Boolean.

AxisGroup

Returns the type of axis group. Read/write XlAxisGroup.

BarShape

Returns or sets the shape used for a single series in a 3-D bar or column chart. Read/write XlBarShape.

Border

Returns the border of the object. Read-only ChartBorder.

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. Read/write Variant.

ChartType

Returns or sets the chart type. Read/write XlChartType.

Creator

Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long.

ErrorBars

Returns the error bars for the series. Read-only ErrorBars.

Explosion

Returns or sets the explosion value for a pie-chart or doughnut-chart slice. Read/write Long.

Format

Returns the line, fill, and effect formatting for the object. Read-only ChartFormat.

Formula

Returns or sets the object's formula in A1-style notation and in the language of the macro. Read/write String.

FormulaLocal

Returns or sets the formula for the object, using A1-style references in the language of the user. Read/write String.

FormulaR1C1

Returns or sets the formula for the object, using R1C1-style notation in the language of the macro. Read/write String.

FormulaR1C1Local

Returns or sets the formula for the object, using R1C1-style notation in the language of the user. Read/write String.

Has3DEffect

True if the series has a three-dimensional appearance. Read/write Boolean.

HasDataLabels

True if the series has data labels. Read/write Boolean.

HasErrorBars

True if the series has error bars. Read/write Boolean.

HasLeaderLines

True if the series has leader lines. Read/write Boolean.

InvertColor

Returns or sets the fill color for negative data points in a series. Read/write.

InvertColorIndex

Returns or sets the fill color for negative data points in a series. Read/write.

InvertIfNegative

True if Microsoft Word inverts the pattern in the object when it corresponds to a negative number. Read/write Variant.

LeaderLines

Returns the leader lines for the series. Read-only LeaderLines.

MarkerBackgroundColor

Sets the marker background color as an RGB value or returns the corresponding color index value. Read/write Long.

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. Read/write Long.

MarkerForegroundColor

Sets the marker foreground color as an RGB value or returns the corresponding color index value. Read/write Long.

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. Read/write Long.

MarkerSize

Returns or sets the data-marker size, in points. Read/write Long.

MarkerStyle

Returns or sets the marker style for a point or series in a line chart, scatter chart, or radar chart. Read/write XlMarkerStyle.

Name

Returns or sets the name of the object. Read/write String.

Parent

Returns the parent for the specified object. Read-only Object.

PictureType

Returns or sets a value that specifies how pictures are displayed on a column or bar picture chart. Read/write XlChartPictureType.

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. Read/write Double.

PlotColorIndex

Returns an index value that is used internally to associate series formatting with chart elements. Read-only.

PlotOrder

Returns or sets the plot order for the selected series within the chart group. Read/write Long.

Shadow

Returns or sets a value that indicates whether the object has a shadow. Read/write Boolean.

Smooth

True if curve smoothing is enabled for the line chart or scatter chart. Read/write Boolean.

Type

Returns or sets the series type. Read/write Long.

Values

Returns or sets a collection of all the values in the series. Read/write Variant.

XValues

Returns or sets an array of x values for a chart series. Read/write Variant.

Show: