XY Scatter Charts Constant in Excel VBA

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

There are quite a lot of XY Scatter 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(xlXYScatter).Chart

.ChartType = xlXYScatterSmooth

XY Scatter chart constants for use with Excel VBA code