Chart.DoughnutGroups Method
On a 2-D chart, returns an object that represents either a single doughnut chart group (a ChartGroup object) or a collection of the doughnut chart groups (a ChartGroups collection).
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Syntax
'Declaration
Function DoughnutGroups ( _
Index As Object _
) As Object
Object DoughnutGroups(
Object Index
)
Parameters
- Index
Type: System.Object
Specifies the chart group.
Return Value
Type: System.Object
Remarks
Optional Parameters
For information on optional parameters, see Optional Parameters in Office Solutions.
Examples
The following code example creates a doughnut Chart and then uses the DoughnutGroups method to set the hole size of the chart.
Private Sub UseDoughnutGroups()
Me.Range("A1", "A5").Value2 = 22
Me.Range("B1", "B5").Value2 = 55
Dim Chart1 As Microsoft.Office.Tools.Excel.Chart = _
Me.Controls.AddChart(Me.Range("D2", "H12"), "Chart1")
Chart1.SetSourceData(Me.Range("A1", "B5"), Excel.XlRowCol.xlColumns)
Chart1.ChartType = Excel.XlChartType.xlDoughnut
Dim group As Excel.ChartGroup = CType(Chart1.DoughnutGroups(1), _
Excel.ChartGroup)
group.DoughnutHoleSize = 80
End Sub
private void UseDoughnutGroups()
{
this.Range["A1", "A5"].Value2 = 22;
this.Range["B1", "B5"].Value2 = 55;
Microsoft.Office.Tools.Excel.Chart chart1 =
this.Controls.AddChart(this.Range["D2", "H12"],
"chart1");
chart1.SetSourceData(this.Range["A1", "B5"],
Excel.XlRowCol.xlColumns);
chart1.ChartType = Excel.XlChartType.xlDoughnut;
Excel.ChartGroup group =
(Excel.ChartGroup)chart1.DoughnutGroups(1);
group.DoughnutHoleSize = 80;
}
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.