Partager via


ChartSheet.ChartGroups(Object) Method

Definition

Gets an object that represents either a single chart group (a ChartGroup object) or a collection of all the chart groups in the chart (a ChartGroups object).

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

Parameters

Index
Object

The chart group number.

Returns

Examples

The following code example uses the ChartGroups method to set the distance between the bars of the current Microsoft.Office.Tools.Excel.ChartSheet.

private void UseChartGroups()
{
    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.xlBarClustered;

    Excel.ChartGroup group =
        (Excel.ChartGroup)this.ChartGroups(1);
    group.GapWidth = 400;
}
Private Sub UseChartGroups()
    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.xlBarClustered

    Dim Group1 As Excel.ChartGroup = _
        CType(Me.ChartGroups(1), Excel.ChartGroup)
    Group1.GapWidth = 400
End Sub

Remarks

The returned collection includes every type of group.

Optional Parameters

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

Applies to