Other Charts Constant in Excel VBA

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

There are plenty of other charts you can use in Excel, ones we haven't mentioned in the previous sections of the table above. Consult the table below for the other constant you can use with the Add or AddChart method. Example uses:

ActiveSheet.Shapes.AddChart(xlArea).Chart

.ChartType = xlSurface

Area chart constants for use with Excel VBA

Other chart constants for use with Excel VBA code