Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Gets or sets the chart type.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Syntax
'Declaration
Property ChartType As XlChartType
Get
Set
XlChartType ChartType { get; set; }
Property Value
Type: Microsoft.Office.Interop.Excel.XlChartType
One of the XlChartType values.
Remarks
Some chart types are not available for PivotChart reports.
Examples
The following code example creates a column Chart and then prompts the user to change the chart to a 3-D pie chart by using the ChartType property.
Private Sub SetChartType()
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.xlColumnClustered
If DialogResult.Yes = _
MessageBox.Show("Change the chart type to a 3-D pie chart?", _
"Example", MessageBoxButtons.YesNo) Then
Chart1.ChartType = Excel.XlChartType.xl3DPie
End If
End Sub
private void SetChartType()
{
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.xlColumnClustered;
if (DialogResult.Yes ==
MessageBox.Show("Change the chart type to a 3-D pie chart?",
"Example", MessageBoxButtons.YesNo))
{
chart1.ChartType = Excel.XlChartType.xl3DPie;
}
}
.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.