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.
|Column Charts||Bar Charts||Line Charts||Pie Charts|
|Scatter Charts||Area Charts||Other Chart Types|