Condividi tramite


ChartSheetBase.ChartType Property

Definition

Gets or sets the ChartSheetBase 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.ChartSheetBase 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