Partager via


ChartSheet.SeriesCollection(Object) Method

Definition

Gets an object that represents either a single series (a Series object) or a collection of all the series (a SeriesCollection collection) in the chart or chart group.

public object SeriesCollection (object Index);
abstract member SeriesCollection : obj -> obj
Public Function SeriesCollection (Optional Index As Object) As Object

Parameters

Index
Object

The name or number of the series.

Returns

Examples

The following code example uses the SeriesCollection method to add data labels to the first data series in the current Microsoft.Office.Tools.Excel.ChartSheet.

private void DisplayDataLabels()
{
    Globals.Sheet1.Range["A1", "A5"].Value2 = 22;
    Globals.Sheet1.Range["B1", "B5"].Value2 = 55;

    this.SetSourceData(Globals.Sheet1.Range["A1", "B5"],
        Excel.XlRowCol.xlColumns);
    this.ChartType = Excel.XlChartType.xl3DColumn;

    Excel.Series series1 =
        (Excel.Series)this.SeriesCollection(1);
    series1.HasDataLabels = true;
}
Private Sub DisplayDataLabels()
    Globals.Sheet1.Range("A1", "A5").Value2 = 22
    Globals.Sheet1.Range("B1", "B5").Value2 = 55

    Me.SetSourceData(Globals.Sheet1.Range("A1", "B5"), _
        Excel.XlRowCol.xlColumns)
    Me.ChartType = Excel.XlChartType.xl3DColumn

    Dim series1 As Excel.Series = _
        CType(Me.SeriesCollection(1), Excel.Series)
    series1.HasDataLabels = True
End Sub

Remarks

Optional Parameters

For information on optional parameters, see Optional Parameters in Office Solutions.

Applies to