Excel VBA Chart Constants

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