Charts and Graphs: Microsoft® Excel® 2010

13. Using Excel VBA to Create Charts

IN THIS CHAPTER

Introducing VBA 359

Learning Tricks of the VBA Trade 363

Coding for New Charting Features in Excel 2010 367

Referencing Charts and Chart Objects in VBA Code 367

Creating a Chart 368

Coding Commands from the Design Tab 372

Using SetElement to Emulate Changes on the Layout Tab 377

Changing a Chart Title Using VBA 382

Emulating Changes on the Format Tab 382

Automating Changes in the Format Series Dialog 400

Exporting a Chart as a Graphic 413

Creating Pivot Charts 415

Creating Data Bars with VBA 420

Creating Sparklines with VBA 423

Introducing VBA

Version 5 of Excel introduced a powerful new macro language called Visual Basic for Applications (VBA). Every copy of Excel shipped since 1993 has ...