ChartSheetBase.ChartGroups Method (Object)


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
Assembly:  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

public object ChartGroups(
	object index


Type: System.Object

The chart group number.

Return Value

Type: System.Object

The returned collection includes every type of group.

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

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

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

    this.SetSourceData(Globals.Sheet1.Range["A1", "B5"],
    this.ChartType = Excel.XlChartType.xlBarClustered;

    Excel.ChartGroup group =
    group.GapWidth = 400;
Return to top