Pie Charts Constant in Excel VBA

Column Charts Bar Charts Line Charts Pie Charts
Scatter Charts Area Charts Other Chart Types  

There are many Pie Charts you can use in Excel. Consult the table below for the correct constant to use with the Add or AddChart method. Click a link above for other chart types. Example uses:

ActiveSheet.Shapes.AddChart(xlPie).Chart

.ChartType = xlPieExploded

 

Pie chart constants for use in Excel VBA code