ChartSheet.ChartType Property (2007 System)
Gets or sets the Microsoft.Office.Tools.Excel.ChartSheet type.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)
Syntax
'Declaration
Public Property ChartType As XlChartType
'Usage
Dim instance As ChartSheet
Dim value As XlChartType
value = instance.ChartType
instance.ChartType = value
public XlChartType ChartType { get; set; }
public:
property XlChartType ChartType {
XlChartType get ();
void set (XlChartType value);
}
public function get ChartType () : XlChartType
public function set ChartType (value : XlChartType)
Property Value
Type: 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.ChartSheet 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.