Chapter 11. Creating Charts

IN THIS CHAPTER

Charting in Excel 2007

197

Coding for New Charting Features in Excel 2007

198

Referencing Charts and Chart Objects in VBA Code

198

Creating a Chart

199

Recording Commands from the Layout or Design Ribbons

202

Using SetElement to Emulate Changes on the Layout Ribbon

209

Changing a Chart Title Using VBA

215

Emulating Changes on the Format Ribbon

215

Using the Watch Window to Discover Object Settings

230

Using the Watch Window to Learn Rotation Settings

233

Creating Advanced Charts

234

Exporting a Chart as a Graphic

244

Creating Pivot Charts

245

Next Steps

248

Charting in Excel 2007

Microsoft took the ambitious leap to attempt to replace the entire charting engine on which they relied for the past 15 years. Although I appreciate their ...

Get Business Solutions VBA and Macros for Microsoft® Office Excel® 2007 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