Details
Author: Walkenbach, John
ISBN: 0-7645-1764-3
Publisher: Jossey-Bass (Wiley), 2002, 518 pp.
List price: $44.99 (US)
Includes: CD-ROM, discount coupon for PUP v5
Status: Available
Target Reader: This book is intended for intermediate to advanced users who want to master Excel's charting feature.
Comments: This book starts with the basics of chart-making, and ends up with extensive coverage of creating charts with VBA. In the process, you'll find hundreds of useful examples, and learn insider tips and techniques that will enable you to make Excel do things you may not have thought possible. This book's Technical Editor was Excel charting wiz, Jon Peltier (visit his web site).
CD-ROM Contents:
- More than 150 example workbooks
- An electronic (PDF) version of the book
- A gallery of more than 250 charts (in the form of GIF files)
- Four add-ins written by the author
- "Bonus material" (see the Table of Contents, below)
More:
Table of Contents
Part I: Chart Basics
- Chapter 1. Introduction to Excel Charts
- Chapter 2. Understanding Chart Types
- Chapter 3. Working with Chart Series
- Chapter 4. Formatting and Customizing Charts
- Chapter 5. Working With Trend Lines 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 Charting 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
- Appendix A: What's on the CD-ROM?
Bonus Material
The following chapters are in HTML format on the CD-ROM. They were originally intended to be chapters in the book, but I exceeded the allotted page count.
- Excel's Color System
- Excel Charting FAQ
- Other Charting Resources