AnyBook4Less.com	Find the Best Price on the Web Order from a Major Online Bookstore
Home  |  Store List  |  FAQ  |  Contact Us  |
Ultimate Book Price Comparison Engine Save Your Time And Money Keyword AuthorISBN

Title: Excel Charts by John Walkenbach ISBN: 0-7645-1764-3 Publisher: John Wiley & Sons Pub. Date: 05 November, 2002 Format: Paperback Volumes: 1 List Price(USD): $44.99

Your Country USA Canada United Kingdom Australia Austria Belgium France Germany Italy Netherlands Switzerland Currency AutoUSD CAD GBP EUR AUD CHF Delivery Only cheapest delivery All delivery options Include Used Books Are you a club member of: Barnes and Noble Books A Million Chapters.Indigo.ca

Average Customer Rating: 3.67 (3 reviews)

Rating: 5
Summary: Yet another winner from Walkenbach
Comment: I've gotten so much out of all of John's books I bought this one no questions asked. I've done a lot of custom charts via VBA and this book is a great help in quickly designing useful and complex charts w/o a lot of effort (just look up how John did it).

Rating: 1
Summary: Errors, errors
Comment: This book allots much space to stuff you find everywhere - what is a pivot table, for example - and on matters of conjecture and taste -does a pie chart "accurately" portray the data, for example. This space could be put to better use.

The section most interesting to me is Chapter 7 (30 pages) - Creating Interactive Charts. Unfortunately, there are errors. Some are only annoying, for example, on p. 213 telling us to enter Sheet1!Dates when the correct entry is =Sheet1!Date (plural is a typo, and no equals sign means no success). Simple errors, but I didn't like trial and error to discover the correct entry.

Other errors are tougher to fix, as on p. 228 where we are told to enter =N(OFFSET(Dates,(ROW(OFFSET($A$1 ... etc)) (I haven't filled in all the line). This procedure doesn't work at all, and an explanation of how it is supposed to work is "beyond the scope of the book". In trying to fix it, I found my own interactive graph that plots every N'th point and automatically adjusts to fit the selected data. Is a thank you in order?

Bottom Line: This book is padded and contains errors that consume much time.

Rating: 5
Summary: Excellent
Comment: If your objective is to master the Charting feature of Excel, I bet that this book will exceed your expectations. Although most the material is advanced every user could benefit (The first Chapter offers a nice introduction to Excel Charts for novices).
Knowledge of formulas and named formulas is necessary for certain examples in the second part of the book. You will be amazed of how many ways there are to customize and improve your charts, you will do things that you never thought possible in Excel. Excel's help file and other books in Excel will never give you the tricks and the work-arounds that you will learn from Walkenbach's book. Some of the most interesting Chart Techniques are :
How to create combination Charts, how to Add a secondary axis,
How to put several Charts on the same Chart Sheet. Scrolling
charts, Self Expanding Charts. Adding Checkboxes to charts. Box
plot and How to plot Mathematical Functions in Excel.
I am sure that you will find many many more useful techniques.