Home and Learn - Free Excel VBA Course
Excel VBA has quite a lot of constants you can use for chart types. In a previous section, we used xlColumnClustered. We used it like this:
.ChartType = xlColumnClustered
In the links below, you'll find all the VBA constant you can use in place of xlColumnClustered. You'll also see images of what each chart type looks like.
Each link opens in a new browser tab.