Series Series Series Interface

Definition

Represents a series in a chart.

public interface class Series
[System.Runtime.InteropServices.Guid("40810760-068A-4486-BEC9-8EA58C7029F5")]
public interface Series
Public Interface Series
Attributes

Remarks

The Series object is a member of the SeriesCollection collection.

Properties

Application Application Application

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

ApplyPictToEnd ApplyPictToEnd ApplyPictToEnd

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

ApplyPictToFront ApplyPictToFront ApplyPictToFront

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

ApplyPictToSides ApplyPictToSides ApplyPictToSides

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

AxisGroup AxisGroup AxisGroup

Returns an XlAxisGroup value that represents the type of axis group. Read/write.

BarShape BarShape BarShape

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

Border Border Border

Returns a ChartBorder object that represents the border of the object. Read-only.

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

ChartType ChartType ChartType

Returns or sets the chart type. Read/write Microsoft.Office.Core.XlChartType.

Creator Creator Creator

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

ErrorBars ErrorBars ErrorBars

Returns an ErrorBars object that represents the error bars for the series. Read-only.

Explosion Explosion 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). Read/write Integer.

Fill Fill Fill

Returns the ChartFillFormat for this series.

Format Format Format

Returns the line, fill, and effect formatting for the object.

Read-only ChartFormat.

Formula Formula 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 FormulaLocal FormulaLocal

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

FormulaR1C1 FormulaR1C1 FormulaR1C1

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

FormulaR1C1Local FormulaR1C1Local FormulaR1C1Local

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

Has3DEffect Has3DEffect Has3DEffect

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

HasDataLabels HasDataLabels HasDataLabels

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

HasErrorBars HasErrorBars HasErrorBars

True if the series has error bars. This property isn’t available for 3-D charts. Read/write Boolean.

HasLeaderLines HasLeaderLines HasLeaderLines

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

Interior Interior Interior

Returns the Interior object for the series.

InvertColor InvertColor InvertColor

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

InvertColorIndex InvertColorIndex InvertColorIndex

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

InvertIfNegative InvertIfNegative InvertIfNegative

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

IsFiltered IsFiltered IsFiltered

Returns or sets a Boolean (bool in C#) that determines whether the specified chart series is filtered out from the chart. Read-write.

LeaderLines LeaderLines LeaderLines

Returns a LeaderLines object that represents the leader lines for the series. Read-only.

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

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

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

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

MarkerSize MarkerSize MarkerSize

Returns or sets the data-marker size, in points. Can be a value from 2 through 72. Read/write Integer.

MarkerStyle MarkerStyle 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 Name Name

Returns or sets a String value that represents the name of the object.

Parent Parent Parent

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

PictureType PictureType PictureType

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

PictureUnit PictureUnit PictureUnit

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).

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

PlotColorIndex PlotColorIndex PlotColorIndex

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

PlotOrder PlotOrder PlotOrder

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

Shadow Shadow Shadow

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

Smooth Smooth Smooth

True if curve smoothing is turned on for the line chart or scatter chart. Applies only to line and scatter charts. Read/write.

Type Type Type

Returns or sets a Integer value that represents the series type.

Values Values Values

Returns or sets a Object value that represents a collection of all the values in the series.

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

Methods

ApplyCustomType(XlChartType) ApplyCustomType(XlChartType) ApplyCustomType(XlChartType)

Applies a standard or custom chart type to a series.

ApplyDataLabels(XlDataLabelsType, Object, Object, Object, Object, Object, Object, Object, Object, Object) ApplyDataLabels(XlDataLabelsType, Object, Object, Object, Object, Object, Object, Object, Object, Object) ApplyDataLabels(XlDataLabelsType, Object, Object, Object, Object, Object, Object, Object, Object, Object)

Applies data labels to a series.

ClearFormats() ClearFormats() ClearFormats()

Clears the formatting of the object.

Copy() Copy() Copy()

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

DataLabels(Object) DataLabels(Object) DataLabels(Object)

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() Delete() Delete()

Deletes the object.

ErrorBar(XlErrorBarDirection, XlErrorBarInclude, XlErrorBarType, Object, Object) ErrorBar(XlErrorBarDirection, XlErrorBarInclude, XlErrorBarType, Object, Object) ErrorBar(XlErrorBarDirection, XlErrorBarInclude, XlErrorBarType, Object, Object)

Applies error bars to the series. Object.

Paste() Paste() Paste()

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

Points(Object) Points(Object) Points(Object)

Returns a collection of all the points in the series.

Select() Select() Select()

Selects the object.

Trendlines(Object) Trendlines(Object) Trendlines(Object)

Returns a collection of all the trendlines for the series.

Applies to