Home and Learn - Free Excel VBA Course

Column Charts Constant in Excel VBA

There are quite a lot of Column 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(xlColumnClustered).Chart

.ChartType = xlColumnStacked