Series members

Represents a series in a chart.

The Series type exposes the following members.

  Name Description
Public property 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.
Public property ApplyPictToEnd True if a picture is applied to the end of the point or all points in the series. Read/write Boolean.
Public property ApplyPictToFront True if a picture is applied to the front of the point or all points in the series. Read/write Boolean.
Public property ApplyPictToSides True if a picture is applied to the sides of the point or all points in the series. Read/write Boolean.
Public property AxisGroup Returns an XlAxisGroup value that represents the type of axis group. Read/write.
Public property BarShape Returns or sets the shape used for a single series in a 3-D bar or column chart. Read/write XlBarShape.
Public property Border Returns a ChartBorder object that represents the border of the object. Read-only.
Public property 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.
Public property ChartType Returns or sets the chart type. Read/write Microsoft.Office.Core.XlChartType.
Public property Creator Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Integer.
Public property ErrorBars Returns an ErrorBars object that represents the error bars for the series. Read-only.
Public property 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.
Public property Fill Returns the ChartFillFormat for this series.
Public property Format Returns the line, fill, and effect formatting for the object. Read-only ChartFormat.
Public property Formula Returns or sets a String value that represents the object's formula in A1-style notation and in the language of the macro.
Public property FormulaLocal Returns or sets the formula for the object, using A1-style references in the language of the user. Read/write String.
Public property FormulaR1C1 Returns or sets the formula for the object, using R1C1-style notation in the language of the macro. Read/write String.
Public property FormulaR1C1Local Returns or sets the formula for the object, using R1C1-style notation in the language of the user. Read/write String.
Public property Has3DEffect True if the series has a three-dimensional appearance. Read/write Boolean.
Public property HasDataLabels True if the series has data labels. Read/write Boolean.
Public property HasErrorBars True if the series has error bars. This property isn’t available for 3-D charts. Read/write Boolean.
Public property HasLeaderLines True if the series has leader lines. Read/write Boolean.
Public property Interior Returns the Interior object for the series.
Public property InvertColor Gets or sets the fill color for negative data points in a series.
Public property InvertColorIndex Gets or sets the fill color for negative data points in a series.
Public property InvertIfNegative True if Microsoft Word inverts the pattern in the object when it corresponds to a negative number. Read/write Boolean.
Public property IsFiltered Returns or sets a Boolean (bool in C#) that determines whether the specified chart series is filtered out from the chart. Read-write.
Public property LeaderLines Returns a LeaderLines object that represents the leader lines for the series. Read-only.
Public property 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.
Public property 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
Public property 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.
Public property 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.
Public property MarkerSize Returns or sets the data-marker size, in points. Can be a value from 2 through 72. Read/write Integer.
Public property MarkerStyle Returns or sets the marker style for a point or series in a line chart, scatter chart, or radar chart. Read/write XlMarkerStyle.
Public property Name Returns or sets a String value that represents the name of the object.
Public property Parent Returns the parent for the specified object. Read-only Object.
Public property PictureType Returns or sets a XlChartPictureType value that represents the way pictures are displayed on a column or bar picture chart.
Public property 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).
Public property 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.
Public property PlotColorIndex Gets an index value that is used internally to associate series formatting with chart elements.
Public property PlotOrder Returns or sets the plot order for the selected series within the chart group. Read/write Integer.
Public property Shadow Returns or sets a Boolean value that determines if the object has a shadow.
Public property Smooth True if curve smoothing is turned on for the line chart or scatter chart. Applies only to line and scatter charts. Read/write.
Public property Type Returns or sets a Integer value that represents the series type.
Public property Values Returns or sets a Object value that represents a collection of all the values in the series.
Public property 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.
Top

  Name Description
Public method ApplyCustomType Applies a standard or custom chart type to a series.
Public method ApplyDataLabels Applies data labels to a series.
Public method ClearFormats Clears the formatting of the object.
Public method Copy If the series has a picture fill, then this method copies the picture to the Clipboard.
Public method 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).
Public method Delete Deletes the object.
Public method ErrorBar Applies error bars to the series. Object.
Public method Paste Pastes a picture from the Clipboard as the marker on the selected series.
Public method Points Returns a collection of all the points in the series.
Public method Select Selects the object.
Public method Trendlines Returns a collection of all the trendlines for the series.
Top
Show:
© 2014 Microsoft