- Shopping Bag ( 0 items )
* 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
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.
Posted June 5, 2003
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.Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Posted May 28, 2003
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 editionWas this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Posted October 30, 2011
No text was provided for this review.