Excel Charts

556 Pages·2002·11.48 MB·English

by  John Walkenbach

517643 cover 10/9/02 1:28 PM Page 1
Everything you need to know about
(cid:2) Creating and formatting high-impact charts for
CD-ROM
business, science, and education
Included
E
(cid:2) Selecting the correct chart for your data
E XC E L
(cid:2) Customizing your charts with pictures, graphics,
and shapes
(cid:2) Understanding the tricks of the trade that enable John Walkenbach, X
principal of JWalk and
you to create “impossible” charts
Associates Inc., is a
leading authority on C C
(cid:2) Creating easy-to-use interactive charts
spreadsheet software
HARTS
(cid:2) Using VBA to create and modify charts and creator of the E
award-winning Power
Utility Pak. He has written
more than 30 spreadsheet L
books and over 300
articles and reviews for
publications including
“I was astonished
“Mr. Spreadsheet” Presents the Only PC World, InfoWorld,and C
by how much I
Windows. He also
Definitive Guide to Excel Charts John Walkenbach
learned from this maintains the popular
Spreadsheet Page at
If you thought you knew all that Excel book — it’s a www.j-walk.com/ss. H
must-read for “Mr. Spreadsheet,” author of
can do, think again! In this comprehensive
Excel 2002 Power Programming with VBA
volume, “Mr. Spreadsheet” John anyone who wants
A
Walkenbach begins by explaining Excel’s to explore the full
built-in charting basics and goes on to help range of Excel
you master trendlines, AutoShapes, pivot charts” R
charts, and dozens of other capabilities in
–Jon M. Peltier, Microsoft Excel MVP
both Excel 2000 and 2002. Using his expert T
techniques as well as his exclusive Power
S
Utility Pak and JWalk Chart Tools, included
CD-ROM Includes
on the bonus CD-ROM, you’ll produce
polished, professional charts that demand • Code, scripts, examples, and all sample charts from the book
attention. While Excel books abound, • JWalk Chart Tools, an add-in created by the author that comprises
six useful chart-related utilities
this is the onlyone devoted solely to the
• Trial version of the author’s award-winning Power Utility Pak 5 Walkenbach
benefits and features of Excel’s charting
System Requirements: PC running Windows 98 or later. Microsoft
capacity.
Excel. See the “What’s on the CD” Appendix for details and
complete system requirements.
ISBN: 0-7645-1764-3
*85555-IFBJFf Shelving Category Price
,!7IA7G4-fbhgei!:P;o;O;t;t
Excel/Spreadsheets $44.99 US
$67.99 CAN
Reader Level £33.50 UK Includes Power Utility Pak v5
Intermediate to Advanced
and more on CD-ROM
Cover by: Daniela Richardson

a517643 FM.F 10/14/02 8:38 AM Page i
Excel Charts
a517643 FM.F 10/14/02 8:38 AM Page ii
a517643 FM.F 10/14/02 8:38 AM Page iii
Excel Charts
John Walkenbach
a517643 FM.F 10/14/02 8:38 AM Page iv
Excel Charts
Published by
Wiley Publishing, Inc.
10475 Crosspoint Boulevard
Indianapolis, IN 46256
www.wiley.com
Copyright © 2003 by Wiley Publishing, Inc., Indianapolis, Indiana
Published simultaneously in Canada
Library of Congress Control Number: 2002110312
ISBN: 0-7645-1764-3
Manufactured in the United States of America
10 9 8 7 6 5 4 3 2 1
1O/QR/RR/QS/IN
No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or
by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted
under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission
of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance
Center, 222 Rosewood Drive, Danvers, MA 01923, [phone], fax [phone]. Requests to the Publisher
for permission should be addressed to the Legal Department, Wiley Publishing, Inc., 10475 Crosspoint Blvd.,
Indianapolis, IN 46256, [phone], fax [phone], E-Mail: [email protected].
LIMIT OF LIABILITY/DISCLAIMER OF WARRANTY: WHILE THE PUBLISHER AND AUTHOR HAVE
USED THEIR BEST EFFORTS IN PREPARING THIS BOOK, THEY MAKE NO REPRESENTATIONS OR
WARRANTIES WITH RESPECT TO THE ACCURACY OR COMPLETENESS OF THE CONTENTS OF THIS
BOOK AND SPECIFICALLY DISCLAIM ANY IMPLIED WARRANTIES OF MERCHANTABILITY OR
FITNESS FOR A PARTICULAR PURPOSE. NO WARRANTY MAY BE CREATED OR EXTENDED BY SALES
REPRESENTATIVES OR WRITTEN SALES MATERIALS. THE ADVICE AND STRATEGIES CONTAINED
HEREIN MAY NOT BE SUITABLE FOR YOUR SITUATION. YOU SHOULD CONSULT WITH A
PROFESSIONAL WHERE APPROPRIATE. NEITHER THE PUBLISHER NOR AUTHOR SHALL BE LIABLE
FOR ANY LOSS OF PROFIT OR ANY OTHER COMMERCIAL DAMAGES, INCLUDING BUT NOT LIMITED
TO SPECIAL, INCIDENTAL, CONSEQUENTIAL, OR OTHER DAMAGES.
For general information on our other products and services or to obtain technical support, please contact
our Customer Care Department within the U.S. at [phone], outside the U.S. at [phone] or fax
[phone].
Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not
be available in electronic books.
Trademarks:Wiley, the Wiley publishing logo and related trade dress are trademarks or registered trademarks
of Wiley Publishing, Inc., in the United States and other countries, and may not be used without written
permission. All other trademarks are the property of their respective owners. Wiley Publishing, Inc., is not
associated with any product or vendor mentioned in this book.
is a trademark of Wiley Publishing, Inc.
a517643 FM.F 10/14/02 8:38 AM Page v
About the Author
John Walkenbach is a leading authority on spreadsheet software and principal of
JWalk and Associates Inc., a small San Diego–based consulting firm that specializes
in spreadsheet application development. John is the author of about 30 spreadsheet
books and has written more than 300 articles and reviews for a variety of publica-
tions, including PC World, InfoWorld, PC Magazine, Windows,and PC/Computing.
He also maintains a popular Web site (The Spreadsheet Page, www.j-walk.com/ss)
and is the developer of the Power Utility Pak, an award-winning add-in for
Microsoft Excel. John graduated from the University of Missouri and earned a
Masters and Ph.D. degree from the University of Montana.
a517643 FM.F 10/14/02 8:38 AM Page vi
Credits
ACQUISITIONS EDITOR PROJECT COORDINATOR
Greg Croy Nancee Reeves
PROJECT EDITOR GRAPHICS AND PRODUCTION
Susan Christophersen SPECIALISTS
Beth Brooks
TECHNICAL EDITOR Jeremey Unger
Jon Peltier
QUALITY CONTROL TECHNICIAN
COPY EDITOR Andy Hollandbeck
Susan Christophersen
PERMISSIONS EDITORS
EDITORIAL MANAGER Laura Moss
Carol Sheehan Carmen Krikorian
VICE PRESIDENT AND MEDIA DEVELOPMENT SPECIALIST
EXECUTIVE GROUP PUBLISHER Megan Decraene
Richard Swadley
PROOFREADING AND INDEXING
VICE PRESIDENT AND TECHBOOKS Production Services
EXECUTIVE PUBLISHER
Bob Ipsen
EXECUTIVE EDITORIAL DIRECTOR
Mary Bednarek
a517643 FM.F 10/14/02 8:38 AM Page vii
For Pamn.
a517643 FM.F 10/14/02 8:38 AM Page viii