Series Interface
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Represents a series in a chart. The Series object is a member of the SeriesCollection collection.
public interface class Series[System.Runtime.InteropServices.Guid("0002086B-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface SeriesPublic Interface Series- Attributes
Properties
| Application |
Returns an Application object that represents the Microsoft Excel application. 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 group for the specified chart group or series. Read/write XlAxisGroup. |
| BarShape |
Returns or sets the shape used with the 3-D bar or column chart. Read/write XlBarShape. |
| Border |
Returns a Border object that represents the border of the object. |
| BubbleSizes |
Returns or sets a string that refers to the worksheet cells containing the size data for the bubble chart. Applies only to bubble charts. Read/write Object. |
| ChartType |
Returns or sets the chart type. Read/write XlChartType. |
| Creator |
Returns a 32-bit integer that indicates the application in which this object was created. If the object was created in Microsoft Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C. Read-only XlCreator. |
| ErrorBars |
Returns an ErrorBars object that represents the error bars for the series. Read-only. |
| 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 |
Returns a FillFormat object that contains fill formatting properties for the specified chart or shape. Read-only. |
| Format |
Returns the ChartFormat object. Read-only. |
| Formula |
Returns or sets the object's formula in A1-style notation. 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. 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. Applies only to bubble charts. Read/write Boolean. |
| HasDataLabels |
True if the series has data labels. Read/write Boolean. |
| HasErrorBars |
True if the series has error bars. This property isn’t available for 3-D charts. Read/write Boolean. |
| HasLeaderLines |
True if the series has leader lines. Read/write Boolean. |
| Interior |
Returns an Interior object that represents the interior of the specified object. |
| InvertColor |
Gets or sets the fill color for negative data points in a series. |
| InvertColorIndex |
Gets 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. Read/write Boolean. |
| IsFiltered |
This setting controls whether the series has been filtered out from the chart. The default value is False. Boolean (bool in C#) Read/Write. |
| LeaderLines |
Returns a LeaderLines object that represents the leader lines for the series. Read-only. |
| MarkerBackgroundColor |
Returns or sets the marker background color as an RGB value. Applies only to line, scatter, and radar charts. Read/write Integer. |
| MarkerBackgroundColorIndex |
Returns or sets the marker background color. Applies only to line, scatter, and radar charts. Read/write XlColorIndex. |
| MarkerForegroundColor |
Returns or sets the foreground color of the marker as an RGB value. Applies only to line, scatter, and radar charts. Read/write Integer. |
| MarkerForegroundColorIndex |
Returns or sets the marker foreground color. Applies only to line, scatter, and radar charts. Read/write XlColorIndex. |
| MarkerSize |
Returns or sets the data-marker size in points. Read/write Integer. |
| 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 object for the specified object. Read-only. |
| PictureType |
Returns or sets the way pictures are displayed on a column or bar picture chart. Read/write XlChartPictureType. |
| PictureUnit |
Returns or sets the unit for each picture on the chart if the PictureType property is set to xlScale (if not, this property is ignored). Read/write Integer. |
| 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. |
| PlotColorIndex |
Gets 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. Read/write Integer. |
| Shadow |
True if the font is a shadow font or if the object has a shadow. Read/write Boolean. |
| 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 |
Returns or sets the chart or series type. Read/write Integer. |
| Values |
Returns or sets a collection of all the values in the series. This can be a range on a worksheet or an array of constant values, but not a combination of both. Read/write Object. |
| 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
| _ApplyDataLabels(XlDataLabelsType, Object, Object, Object) |
Reserved for internal use. |
| ApplyCustomType(XlChartType) |
Applies a standard or custom chart type to a series. |
| ApplyDataLabels(XlDataLabelsType, Object, Object, Object, Object, Object, Object, Object, Object, Object) |
Applies data labels to a point, a series, or all the series in a chart. |
| ClearFormats() |
Clears the formatting of the object. |
| Copy() |
Copies the object to the Clipboard. Copies a picture of the point or series to the Clipboard. |
| 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() |
Deletes the object. |
| ErrorBar(XlErrorBarDirection, XlErrorBarInclude, XlErrorBarType, Object, Object) |
Applies error bars to the series. Object. |
| Paste() |
Pastes a picture from the Clipboard as the marker on the selected series. This method can be used on column, bar, line, or radar charts, and it sets the MarkerStyle property to xlMarkerStylePicture. |
| Points(Object) |
Returns an object that represents a single point (a Point object) or a collection of all the points (a Points collection) in the series. Read-only. |
| Select() |
Selects the object. |
| Trendlines(Object) |
Returns an object that represents a single trendline (a Trendline object) or a collection of all the trendlines (a Trendlines collection) for the series. |