ChartSheetBase.ChartType Property

 
Namespace:   Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

public XlChartType ChartType { get; set; }

Property Value

Type: Microsoft.Office.Interop.Excel.XlChartType

One of the XlChartType values.

Some chart types are not available for PivotChart reports.

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;
}
Return to top
Show: