Condividi tramite


ChartSheet.ChartType Property

Definition

Gets or sets the ChartSheet type.

public:
 property Microsoft::Office::Interop::Excel::XlChartType ChartType { Microsoft::Office::Interop::Excel::XlChartType get(); void set(Microsoft::Office::Interop::Excel::XlChartType value); };
public Microsoft.Office.Interop.Excel.XlChartType ChartType { get; set; }
member this.ChartType : Microsoft.Office.Interop.Excel.XlChartType with get, set
Public Property ChartType As XlChartType

Property Value

One of the XlChartType values.

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 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;
}
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

Remarks

Some chart types are not available for PivotChart reports.

Applies to