|
||||||||||||||||||||||||||||||||||||||||
|
Excel Charts
Product Details
Customer Reviews Yet another winner from WalkenbachI'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). Errors, errorsThis 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.
RECOMMENDED Microsoft Excel books for Intermediate / Advanced Users
RECOMMENDED MICROSOFT EXCEL TIPS |
• Excel VBA books |
||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||