Udostępnij za pośrednictwem


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

See Also

Reference

ChartSheetBase Class

Microsoft.Office.Tools.Excel Namespace