Excel 2016 VBA and Macros

15. Creating Charts

In This Chapter

Contrasting the Good and Bad VBA to Create Charts

Planning for More Charts to Break

Using .AddChart2 to Create a Chart

Understanding Chart Styles

Formatting a Chart

Creating a Combo Chart

Exporting a Chart as a Graphic

Considering Backward Compatibility

Next Steps

Charting in Excel 2016 picks up six new chart types and also moves to a modern charting engine. While this sounds like a good thing, the transition is going to introduce chaos to your charting macros over the next several years. Here’s why: You have 73 old-style charts where the macro recorder works and you can create charts using VBA code that has worked reliably. The 6 new-style charts are not supported by the macro recorder. The VBA code is buggy. ...