Excel Charts / Edition 1 by John Walkenbach | 9780764517648 | Paperback | Barnes & Noble
Excel Charts / Edition 1

Excel Charts / Edition 1

1.0 3
by John Walkenbach
     
 

ISBN-10: 0764517643

ISBN-13: 9780764517648

Pub. Date: 11/11/2002

Publisher: Wiley

* 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,

Overview

* 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

Product Details

ISBN-13:
9780764517648
Publisher:
Wiley
Publication date:
11/11/2002
Edition description:
BK&CD-ROM
Pages:
552
Product dimensions:
7.40(w) x 9.30(h) x 1.20(d)

Related Subjects

Table of Contents

Acknowledgments.

Introduction.

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.

Index.

End-User License Agreement.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >

Excel Charts 1 out of 5 based on 0 ratings. 3 reviews.
Anonymous More than 1 year ago
Guest More than 1 year ago
Aside from tiring digressions, like the aesthetics of pie charts, and well-worn topics, like what is a pivot table, this work suffers from errors that make it hard to use because you must figure out what really will work. An example is Ch 7 on interactive charts where on p. 213 incorrect entries are provided (they omit an equals sign and have mistakenly used 'dates' instead of 'date'). Fixing these things is trouble, but eventually you find what is needed. On p. 228 and 229, however, incorrect info is given and no guidance that could help in fixing the problem. Instead of telling us how it works, which might lead us in the right direction, we are told that 'explanation is beyond the scope of the book' but 'it's not necessary that you fully understand them in order to use them'. *BOTTOM LINE*: wait for corrections.
Guest More than 1 year ago
My interest was Chapter 7, creating interactive charts. Unfortunately, I found the instructions contained a number of errors that detract from ease of use. For example, on p. 213 we are told to enter Sheet1!Dates, but the correct entry is =Sheet1!Date. Ommision of the = sign or addition of the plural 's' means no results - big time waster. On p. 228 we are told to enter =N(OFFSET(...)) and on p. 229 to define the variable NewDates with a similar expression (I haven't filled in all the details). Neither suggestion works, and we are told that an explanation of how they are supposed to work is 'beyond the scope of the book'. I wasn't able to find the correct entries - BIG waste of time. Bottom line: sloppy, sloppy editing - wait for the next edition