ChartSheetBase.ChartType Property
Gets or sets the Microsoft.Office.Tools.Excel.ChartSheetBase type.
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 Property ChartType As XlChartType
Get
Set
public 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 uses the ChartType property to set the type of the current Microsoft.Office.Tools.Excel.ChartSheetBase to a 3-D clustered bar chart.
Private Sub AdjustChartSheet()
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.xl3DBarClustered
End Sub
private void AdjustChartSheet()
{
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.xl3DBarClustered;
}
.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.