O'Reilly logo

Excel 2016 VBA and Macros by Tracy Syrstad, Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

15. Creating Charts

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required