This documentation is archived and is not being maintained.

Series Properties 

  Name Description
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.
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.
InvertIfNegative True if Microsoft Excel inverts the pattern in the item when it corresponds to a negative number. Read/write Boolean.
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.
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.
Show: