Appendix - Chart Type 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 sections 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.
Quick Jump