Table of Contents

Acknowledgments.

Introduction.

Part I: Chart Basics.

Chapter 1: Introducing Excel Charts.

Chapter 2: Understanding Chart Types.

Chapter 3: Working with Chart Series.

Chapter 4: Formatting and Customizing Charts.

Chapter 5: Working with Trendlines and Error Bars.

Chapter 6: Working with AutoShapes and Other Graphics.

Part II: Mastering Charts.

Chapter 7: Creating Interactive Charts.

Chapter 8: Charting Techniques and Tricks.

Chapter 9: Using Pivot Charts.

Chapter 10: Using Excel Charts in Other Applications.

Chapter 11: Avoiding Common Chart-Making Mistakes.

Chapter 12: Just for Fun.

Part III: Using VBA with Charts.

Chapter 13: Introducing VBA.

Chapter 14: VBA Programming Concepts.

Chapter 15: Understanding Objects, Collections, Properties, and Methods.

Chapter 16: Using VBA with Charts: Examples.

Appendix: What's on the CD-ROM.

Index.

End-User License Agreement.

About the Author

John Walkenbach, principal of JWalk and Associates Inc., is a leading authority on spreadsheet software and creator of the award-winning Power Utility Pak. He has written more than 30 spreadsheet books and over 300 articles and reviews for publications including PC World, InfoWorld, and Windows. He also maintains the popular Spreadsheet Page at www.j-walk.com/ss.

Reviews

"...a unique, accessible book that conveys a lot of powerful thoughts which can be turned into a great success through careful application..." (M2 Best Books, 26 February 2003)