Excel Charts and over one million other books are available for Amazon Kindle. Learn more
CDN$ 30.86
  • List Price: CDN$ 48.99
  • You Save: CDN$ 18.13 (37%)
Only 1 left in stock (more on the way).
Ships from and sold by Amazon.ca.
Gift-wrap available.
Quantity:1
Add to Cart
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Excel Charts Paperback – Nov 29 2002


See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
Paperback
"Please retry"
CDN$ 30.86
CDN$ 27.99 CDN$ 3.03

Join Amazon Student in Canada



Customers Who Bought This Item Also Bought

NO_CONTENT_IN_FEATURE

Product Details

  • Paperback: 552 pages
  • Publisher: Wiley; 1 edition (Nov. 29 2002)
  • Language: English
  • ISBN-10: 0764517643
  • ISBN-13: 978-0764517648
  • Product Dimensions: 23 x 19 x 3 cm
  • Shipping Weight: 839 g
  • Average Customer Review: 3.7 out of 5 stars  See all reviews (3 customer reviews)
  • Amazon Bestsellers Rank: #600,550 in Books (See Top 100 in Books)
  • See Complete Table of Contents


Inside This Book (Learn More)
First Sentence
WHEN MOST PEOPLE THINK OF A spreadsheet product such as Excel, they think of crunching rows and columns of numbers. Read the first page
Explore More
Concordance
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

3.7 out of 5 stars
5 star
2
4 star
0
3 star
0
2 star
0
1 star
1
See all 3 customer reviews
Share your thoughts with other customers

Most helpful customer reviews

1 of 1 people found the following review helpful By johare on May 19 2003
Format: Paperback
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.
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.
Format: Paperback
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).
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.
By Antonios Giannakas on Dec 18 2002
Format: Paperback
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.
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.

Most Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: 18 reviews
54 of 57 people found the following review helpful
Excellent Dec 17 2002
By Antonios Giannakas - Published on Amazon.com
Format: Paperback Verified Purchase
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.
72 of 82 people found the following review helpful
Errors, errors May 19 2003
By johare - Published on Amazon.com
Format: Paperback
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?

What can you do? Walkenbach explains (p. 327) that changes to a pivot table chart that cause updating mean that all formatting is reverted to default. He also explains that pivot-table xy-charts are not possible, and that efforts to get around this basically are trouble. This may be the most useful part of this book: it tells you what can't be done.

Bottom Line: This book is padded and contains errors that consume much time.
3 of 3 people found the following review helpful
Stuff I Never Knew Oct. 23 2007
By C. Elser - Published on Amazon.com
Format: Paperback Verified Purchase
I've been using Excel to create charts for 20 years and thought I knew a lot about creating and modifying charts. I'm only on Chapter 4 and I've already learned a handful of very helpful hints and tips -- and this is just the chapters that cover the basics. I was planning to skip those chapters because I thought they wouldn't cover anything new. Instead I'm glad I didn't as there are a number of shortcuts I would have never known about. There are great examples and the CD lets you try out the options as they are discussed in the book.
3 of 3 people found the following review helpful
Excellent reference on how to use Excel to make really useful charts July 29 2005
By S. Lewis - Published on Amazon.com
Format: Paperback
I must often prepare simple visuals from complex data, aiming to communicate the message in the data at a glance from the audience. This book is an excellent reference for how to easily set up Excel charts to do just that. Chapter 8: Charting Techniques and Tricks is especially valuable and I refer to it all the time. I recommend this as a desktop reference for anyone who creates charts in Excel.
2 of 2 people found the following review helpful
Wrong book Feb. 24 2012
By James Claiborn - Published on Amazon.com
Format: Paperback Verified Purchase
I searched under Excel 2007 graphs and found this book listed. Stupidly I thought it was somehow related to Excel 2007 and went ahead and ordered it. I returned it the next day since it is actually about earlier versions of Excel and since the program changed dramatically with the 2007 revision the book is of no value unless you are using an older version of Excel.Excel Charts

Product Images from Customers

Search

Look for similar items by category


Feedback