Partager via


ChartSheetBase.ColumnGroups Method

On a 2-D chart, returns an object that represents either a single column chart group (a ChartGroup object) or a collection of the column chart groups (a ChartGroups collection).

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

Syntax

'Declaration
Public Function ColumnGroups ( _
    index As Object _
) As Object
public Object ColumnGroups(
    Object index
)

Parameters

Return Value

Type: System.Object

Remarks

Optional Parameters

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

Examples

The following code example uses the ColumnGroups method to set the distance between columns in the current Microsoft.Office.Tools.Excel.ChartSheetBase.

Private Sub UseColumnGroups()
    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.xlColumnClustered

    Dim group As Excel.ChartGroup = _
        CType(Me.ColumnGroups(1), Excel.ChartGroup)
    group.GapWidth = 400
End Sub
private void UseColumnGroups()
{
    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.xlColumnClustered;

    Excel.ChartGroup group =
        (Excel.ChartGroup)this.ColumnGroups(1);
    group.GapWidth = 400;
}

.NET Framework Security

See Also

Reference

ChartSheetBase Class

Microsoft.Office.Tools.Excel Namespace