ChartSheetBase.PieGroups Method

On a 2-D Microsoft.Office.Tools.Excel.ChartSheetBase, returns an object that represents either a single pie chart group (a ChartGroup object) or a collection of the pie 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)

public Object PieGroups(
	Object index
)

Parameters

index
Type: System.Object

Specifies the chart group.

Return Value

Type: System.Object

Optional Parameters

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

The following code example uses the PieGroups method to set the angle at which the first slice in the current Microsoft.Office.Tools.Excel.ChartSheetBase begins.

private void UsePieGroups()
{
    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.xlPie;

    Excel.ChartGroup group =
        (Excel.ChartGroup)this.PieGroups(1);
    group.FirstSliceAngle = 90;
}

Show: