Excel Charts

Excel Charts

4.08 (12 ratings by Goodreads)
By (author) 

Free delivery worldwide

Available. Dispatched from the UK in 1 business day
When will my order arrive?


â 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
show more

Product details

  • Paperback | 552 pages
  • 187.96 x 231.14 x 33.02mm | 839.14g
  • Hungry Minds Inc,U.S.
  • Indianapolis, IN, United States
  • English
  • 1. Auflage
  • 0764517643
  • 9780764517648
  • 911,508

Back cover copy

Everything you need to know about
* Creating and formatting high-impact charts for business, science, and education
* Selecting the correct chart for your data
* Customizing your charts with pictures, graphics, and shapes
* Understanding the tricks of the trade that enable you to create "impossible" charts
* Creating easy-to-use interactive charts
* Using VBA to create and modify charts

"Mr. Spreadsheet" Presents the Only Definitive Guide to Excel Charts

If you thought you knew all that Excel can do, think again! In this comprehensive volume, "Mr. Spreadsheet" John Walkenbach begins by explaining Excel's built-in charting basics and goes on to help you master trendlines, AutoShapes, pivot charts, and dozens of other capabilities in both Excel 2000 and 2002. Using his expert techniques as well as his exclusive Power Utility Pak and JWalk Chart Tools, included on the bonus CD-ROM, you'll produce polished, professional charts that demand attention. While Excel books abound, this is the only one devoted solely to the benefits and features of Excel's charting capacity.

"I was astonished by how much I learned from this book - it's a must-read for anyone who wants to explore the full range of Excel charts"
-Jon M. Peltier, Microsoft Excel MVP

CD-ROM Includes
* Code, scripts, examples, and all sample charts from the book
* JWalk Chart Tools, an add-in created by the author that comprises six useful chart-related utilities
* Trial version of the author's award-winning Power Utility Pak 5

System Requirements: PC running Windows 98 or later. Microsoft Excel. See the "What's on the CD" Appendix for details and complete system requirements.
show more

Table of contents



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.
show more

Review Text

"...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)
show more

Review quote

"...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)
show more

About John Walkenbach

John Walkenbach, principal of JWalk and Associates Inc., is a leading authority on spreadsheet software and creator of the award-winning Power Utility Pak. He has written more than 30 spreadsheet books and over 300 articles and reviews for publications including PC World, InfoWorld, and Windows. He also maintains the popular Spreadsheet Page at www.j-walk.com/ss.
show more

Rating details

12 ratings
4.08 out of 5 stars
5 50% (6)
4 8% (1)
3 42% (5)
2 0% (0)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X