13. Using Excel VBA to Create Charts

In This Chapter

Introducing VBA

Learning Tricks of the VBA Trade

Understanding Backward Compatibility

Referencing Charts and Chart Objects in VBA Code

Understanding the Global Settings

Creating a Chart in Various Excel Versions

Customizing a Chart

Using SetElement to Emulate Changes on the Layout Tab

Formatting a Data Series

Creating Advanced Charts

Exporting a Chart as a Graphic

Creating Pivot Charts

Creating Data Bars with VBA

Creating Sparklines with VBA

Next Steps

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 had a copy of the powerful VBA language hiding behind the worksheets. VBA enables ...

Get Excel® 2013 Charts and Graphs now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial