ChartSheet.ChartGroups Method

Article
01/07/2014

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).

Namespace: Microsoft.Office.Tools.Excel
Assemblies: Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Syntax

'Declaration
Function ChartGroups ( _
    Index As Object _
) As Object

Object ChartGroups(
    Object Index
)

Parameters

Index
Type: System.Object

The chart group number.

Return Value

Type: System.Object

Remarks

The returned collection includes every type of group.

Optional Parameters

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

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 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

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;
}

.NET Framework Security

Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

Partager via