VBA and Macros: Microsoft® Excel® 2010

11. Creating Charts

IN THIS CHAPTER

Charting in Excel 2010

Referencing Charts and Chart Objects in VBA Code

Creating a Chart

Recording Commands from the Layout or Design Tabs

Using SetElement to Emulate Changes on the Layout Tab

Changing a Chart Title Using VBA

Emulating Changes on the Format Tab

Creating Advanced Charts

Exporting a Chart as a Graphic

Creating Pivot Charts

Charting in Excel 2010

Microsoft rewrote the Excel charting engine for Excel 2007. Most code from Excel 2003 will continue to work in Excel 2010.

The following are some important methods and features available in Excel 2010:

• ApplyLayout—This method applies one of the chart layouts available on the Design tab.

• SetElement—This method chooses any of the built-in element ...