This topic has not yet been rated - Rate this topic

ChartSheet.ColumnGroups Method

Visual Studio 2005

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 (in microsoft.office.tools.excel.dll)

Syntax

public virtual Object ColumnGroups (
	[OptionalAttribute] Object Index
)

Parameters

Index: Specifies the chart group.

Remarks

Optional Parameters

For information on optional parameters, see Understanding Optional Parameters in COM Interop.

Example

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

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

Reference

ChartSheet Class
ChartSheet Members
Microsoft.Office.Tools.Excel Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)