Home and Learn - Free Excel VBA Course

Line Charts Constant in Excel VBA

There are plenty of Line 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(xlLine).Chart

.ChartType = xlLineStacked

Line chart constants for use in Excel VBA