Home and Learn - Free Excel VBA Course

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.

Each link opens in a new browser tab.

Column Charts

Bar Charts

Line Charts

Pie Charts

Scatter Charts

Area and Other Charts Types



< 11. 5Chart Forms, 2

Next Lesson: 12.1 TreeViews >