ChartSheet.ChartGroups Method (2007 System)

  • Article

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.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)

Syntax

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

'Usage
Dim instance As ChartSheet 
Dim Index As Object 
Dim returnValue As Object 

returnValue = instance.ChartGroups(Index)

public Object ChartGroups(
    Object Index
)

public:
Object^ ChartGroups(
    Object^ Index
)

public function ChartGroups(
    Index : Object
) : Object

Parameters

Return Value

Type: System.Object

Remarks

The returned collection includes every type of group.

Optional Parameters

For information on optional parameters, see The Variable missing and 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

See Also

Reference

ChartSheet Class

ChartSheet Members

Microsoft.Office.Tools.Excel Namespace