Excel Charts and over 900,000 other books are available for Amazon Kindle . Learn more


or
Sign in to turn on 1-Click ordering.
or
Amazon Prime free trial required. Sign up when you check out. Learn more
More Buying Choices
Have one to sell? Sell yours here
or
Get a £0.25 Amazon.co.uk Gift Card
Excel Charts
 
 
Start reading Excel Charts on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Excel Charts [Paperback]

John Walkenbach
5.0 out of 5 stars  See all reviews (2 customer reviews)
RRP: £33.50
Price: £21.44 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £12.06 (36%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.
Only 2 left in stock--order soon (more on the way).
Want guaranteed delivery by Monday, February 13? Choose Express delivery at checkout. See Details

Formats

Amazon Price New from Used from
Kindle Edition £18.22  
Paperback £21.44  
Trade In this Item for up to £0.25
Trade in Excel Charts for an Amazon.co.uk gift card of up to £0.25, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.

Frequently Bought Together

Excel Charts + Excel 2003 Formulas + Excel 2003 Power Programming with VBA
Price For All Three: £61.57

Show availability and delivery details

Buy the selected items together

Customers Who Bought This Item Also Bought


Product details

  • Paperback: 552 pages
  • Publisher: John Wiley & Sons; Pap/Cdr edition (19 Nov 2002)
  • Language English
  • ISBN-10: 0764517643
  • ISBN-13: 978-0764517648
  • Product Dimensions: 23.2 x 18.8 x 3 cm
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (2 customer reviews)
  • Amazon Bestsellers Rank: 69,713 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Author

John Walkenbach
Discover books, learn about writers, and more.

Visit Amazon's John Walkenbach Page

Product Description

Review

"...a unique, accessible book that conveys a lot of powerful thoughts which can be turned into a great success through careful application..." (M2 Best Books, 26 February 2003)

Product Description

∗ 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

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:

Suggested Tags from Similar Products

 (What's this?)
Be the first one to add a relevant tag (keyword that's strongly related to this product)
 
(3)

Your tags: Add your first tag
 

What Other Items Do Customers Buy After Viewing This Item?


 

Customer Reviews

2 Reviews
5 star:
 (2)
4 star:    (0)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
5.0 out of 5 stars (2 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

17 of 17 people found the following review helpful:
5.0 out of 5 stars Walkenback returns with another excellent book, 27 Dec 2003
By 
P. Joyce (UK) - See all my reviews
(REAL NAME)   
This review is from: Excel Charts (Paperback)
Despite the book being squarely aimed at one particular part of Excel, the book still manages to weigh in at 552 pages - not bad for a single topic within Excel. I would think that the majority of users will need to use some form of charting in their Excel work at some point, so if you need to delve beyond the basic chart wizard, this book gives you everything you need, and more...

It's divided into three parts;

Part I - Chart Basics

This introduces charts, helps you to understand different chart types, series, how to format and customise charts, add trend lines and error bars, and add basic shapes and graphics to your charts to add a little something. Ideal for the beginner, the book even takes you through the chart wizard step by step, and contains an exhaustive description of all basic operations.

Part II - Mastering Charts

Need more than just the basic stuff? This, along with Part III, drew me to the book. This section covers interactive charts, techniques and tricks, pivot charts, exporting charts to other applications, avoiding common mistakes, and some fun chart uses.

Part III - Using VBA with Charts

This part of the book provides a brief overview of VBA, it's programming concepts, and lots of examples of how to work with charts using VBA.

It may not be as useful as one of the 1000+ page behemoths that Walkenbach has released previously, but if you want to know all there is to know about charting under Excel, you'd be hard pressed to find a better source of reference. I always wanted to know lots about charting under Excel, but until this book came along, nothing quite hit the mark.

Make room on your bookcase!

Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


5.0 out of 5 stars Very Good, 6 Jun 2008
By 
Dr. M (Newcastle, UK) - See all my reviews
This review is from: Excel Charts (Paperback)
Great book. Well written and easy to read. Lots of clever tricks that you would just never think of. I have found it to be a very useful book.

It is worth mentioning that his other books cover a lot of the information in this book and his other books are fantastic! (Excel 2003 Formulas & Excel 2003 Power Programming with VBA)
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No

Share your thoughts with other customers: Create your own review
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 4.3 out of 5 stars (15 customer reviews)

53 of 56 people found the following review helpful:
5.0 out of 5 stars Excellent, 18 Dec 2002
By Antonios Giannakas - Published on Amazon.com
This review is from: Excel Charts (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.

71 of 81 people found the following review helpful:
1.0 out of 5 stars Errors, errors, 19 May 2003
By johare "johare4" - Published on Amazon.com
This review is from: Excel Charts (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:
5.0 out of 5 stars Stuff I Never Knew, 23 Oct 2007
By C. Elser - Published on Amazon.com
This review is from: Excel Charts (Paperback)
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.
 Go to Amazon.com to see all 15 reviews  4.3 out of 5 stars 
Were these reviews helpful?   Let us know
 
 
Only search this product's reviews



Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Listmania!

Create a Listmania! list

Look for similar items by category


Look for similar items by subject


Feedback


Amazon.co.uk Privacy Statement Amazon.co.uk Delivery Information Amazon.co.uk Returns & Exchanges