Pub. Date:
Excel Charts / Edition 1

Excel Charts / Edition 1

by John Walkenbach


Current price is , Original price is $46.99. You

Temporarily Out of Stock Online

Please check back later for updated availability.

Product Details

ISBN-13: 9780764517648
Publisher: Wiley
Publication date: 11/11/2002
Pages: 552
Sales rank: 674,264
Product dimensions: 7.40(w) x 9.30(h) x 1.20(d)

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

Table of Contents



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.


End-User License Agreement.

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews

Excel Charts 1 out of 5 based on 0 ratings. 3 reviews.
Anonymous More than 1 year ago
Guest More than 1 year ago
Aside from tiring digressions, like the aesthetics of pie charts, and well-worn topics, like what is a pivot table, this work suffers from errors that make it hard to use because you must figure out what really will work. An example is Ch 7 on interactive charts where on p. 213 incorrect entries are provided (they omit an equals sign and have mistakenly used 'dates' instead of 'date'). Fixing these things is trouble, but eventually you find what is needed. On p. 228 and 229, however, incorrect info is given and no guidance that could help in fixing the problem. Instead of telling us how it works, which might lead us in the right direction, we are told that 'explanation is beyond the scope of the book' but 'it's not necessary that you fully understand them in order to use them'. *BOTTOM LINE*: wait for corrections.
Guest More than 1 year ago
My interest was Chapter 7, creating interactive charts. Unfortunately, I found the instructions contained a number of errors that detract from ease of use. For example, on p. 213 we are told to enter Sheet1!Dates, but the correct entry is =Sheet1!Date. Ommision of the = sign or addition of the plural 's' means no results - big time waster. On p. 228 we are told to enter =N(OFFSET(...)) and on p. 229 to define the variable NewDates with a similar expression (I haven't filled in all the details). Neither suggestion works, and we are told that an explanation of how they are supposed to work is 'beyond the scope of the book'. I wasn't able to find the correct entries - BIG waste of time. Bottom line: sloppy, sloppy editing - wait for the next edition