Excel.Series(object).md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Series object (Excel)	vbaxl10.chm577072	vbaxl10.chm577072	Excel.Series	c7d34b32-8172-f7a0-0a17-f01d44246b64	04/02/2019	medium

Series object (Excel)

Represents a series in a chart.

Remarks

The Series object is a member of the SeriesCollection collection.

Example

Use SeriesCollection (index), where index is the series index number or name, to return a single Series object. The series index number indicates the order in which the series are added to the chart. SeriesCollection(1) is the first series added to the chart, and SeriesCollection(SeriesCollection.Count) is the last one added.

The following example sets the color of the interior for the first series in embedded chart one on Sheet1.

Worksheets("sheet1").ChartObjects(1).Chart. _ 
 SeriesCollection(1).Interior.Color = RGB(255, 0, 0)

Methods

• ApplyDataLabels
• ClearFormats
• Copy
• DataLabels
• Delete
• ErrorBar
• Paste
• Points
• Select
• Trendlines

Properties

• Application
• ApplyPictToEnd
• ApplyPictToFront
• ApplyPictToSides
• AxisGroup
• BarShape
• BubbleSizes
• ChartType
• Creator
• ErrorBars
• Explosion
• Format
• Formula
• FormulaLocal
• FormulaR1C1
• FormulaR1C1Local
• GeoMappingLevel
• GeoProjectionType
• Has3DEffect
• HasDataLabels
• HasErrorBars
• HasLeaderLines
• InvertColor
• InvertColorIndex
• InvertIfNegative
• IsFiltered
• LeaderLines
• MarkerBackgroundColor
• MarkerBackgroundColorIndex
• MarkerForegroundColor
• MarkerForegroundColorIndex
• MarkerSize
• MarkerStyle
• Name
• Parent
• ParentDataLabelOption
• PictureType
• PictureUnit2
• PlotColorIndex
• PlotOrder
• QuartileCalculationInclusiveMedian
• RegionLabelOptions
• Shadow
• Smooth
• Type
• Values
• XValues

See also

• Excel Object Model Reference

[!includeSupport and feedback]