Excel Charts / Edition 1 available in Paperback
- Pub. Date:
* One of the world's best-known Excel experts shows how to master the charting features in Excel 2000 and 2002 to create compelling graphic representations of data
• Covers basic and advanced features, focusing on the new charting featuresprovided in version 2002
• Explains how to select charts for different categories of data, modify data in a chart, deal with missing data, format charts, customize shapes, and give charts a professional look
|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 www.j-walk.com/ss.
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.
Most Helpful Customer Reviews
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.
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