Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

Chart.ChartType Property

Gets or sets the chart type.

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

XlChartType ChartType { get; set; }

Property Value

Type: XlChartType
One of the XlChartType values.

Some chart types are not available for PivotChart reports.

The following code example creates a column Chart and then prompts the user to change the chart to a 3-D pie chart by using the ChartType property.

private void SetChartType()
{
    this.Range["A1", "A5"].Value2 = 22;
    this.Range["B1", "B5"].Value2 = 55;

    Microsoft.Office.Tools.Excel.Chart chart1 =
        this.Controls.AddChart(this.Range["D2", "H12"], 
        "chart1");

    chart1.SetSourceData(this.Range["A1", "B5"], 
        Excel.XlRowCol.xlColumns);
    chart1.ChartType = Excel.XlChartType.xlColumnClustered;

    if (DialogResult.Yes ==
        MessageBox.Show("Change the chart type to a 3-D pie chart?",
        "Example", MessageBoxButtons.YesNo))
    {
        chart1.ChartType = Excel.XlChartType.xl3DPie;
    }
}

Show:
© 2015 Microsoft