Charts en power point

C o n t e n t s a t a G l a n c e

?usinesssolutions
Charts and Graphs for Microsoft Office Excel 2007
® ®
Bill Jelen

1 2 3 4 5 6 7 8 9 10 11 12 13 14

Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .1 Introducing Charts in Excel 2007 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 Customizing Charts . . . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .37 Creating Charts That Show Trends . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81 Creating Charts That Show Differences . . . . . . . . . . . . . . . . . . . . . . 121 Creating Charts That Show Relationships . . . . . . . . . . . . . . . . . . . . 147 Creating Stock Analysis Charts . . . . . . . . . . . . . . . . . . . .. . . . . . . . . 187 Advanced Chart Techniques . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 223 Creating and Using Pivot Charts . . . . . . . . . . . . . . . . . . . . . . . . . . . . 267 Presenting Data Visually Without Charts . . . . . . . . . . . . . . . . . . . . . 281 Presenting Your Excel Data on a Map Using Microsoft MapPoint . 307 Using SmartArt Graphics and Shapes . .. . . . . . . . . . . . . . . . . . . . . . 317 Exporting Your Charts for Use Outside of Excel . . . . . . . . . . . . . . . . 347 Using Excel VBA to Create Charts . . . . . . . . . . . . . . . . . . . . . . . . . . . 357 Knowing When Someone Is Lying to You with a Chart . . . . . . . . . 423 Appendix A: Charting References . . . . . . . . . . . . . . . . . . . . . . . . . . . 431 Index . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 439

800 E. 96th Street Indianapolis, Indiana 46240

Charts and Graphs for Microsoft® Office Excel® 2007
Copyright © 2007 by Que Publishing
All rights reserved. No part of this book shall be reproduced, stored in a retrieval system, or transmitted by any means, electronic, mechanical, photocopying,recording, or otherwise, without written permission from the publisher. No patent liability is assumed with respect to the use of the information contained herein. Although every precaution has been taken in the preparation of this book, the publisher and author assume no responsibility for errors or omissions. Nor is any liability assumed for damages resulting from the use of the informationcontained herein. International Standard Book Number: 0-7897-3610-1 Library of Congress Cataloging-in-Publication Data Jelen, Bill. Charts and graphs for Microsoft Office Excel 2007 / Bill Jelen. p. cm. ISBN 0-7897-3610-1 1. Microsoft Excel (Computer file) 2. Business—Computer programs. 3. Electronic spreadsheets. 4. Charts, diagrams, etc.— Computer programs. I. Title. HF5548.4.M523J447 2007005.54—dc22 2007004763 Printed in the United States of America First Printing: April 2007 10 09 08 07 4 3 2 1

Associate Publisher
Greg Wiegand

Acquisitions Editor
Loretta Yates

Development Editor
Laura Norman

Managing Editor
Gina Kanouse

Project Editor
Michael Thurston

Copy Editor
Kitty Jarrett

Indexer
Cheryl Lenser

Proofreader
Water Crest Publishing

Technical Editors
JuanPablo Gonzalez Bob Umlas

Trademarks
All terms mentioned in this book that are known to be trademarks or service marks have been appropriately capitalized. Que Publish-ing cannot attest to the accuracy of this information. Use of a term in this book should not be regarded as affecting the validity of any trademark or service mark.

Publishing Coordinator
Cindy Teeters

Warning andDisclaimer
Every effort has been made to make this book as complete and as accurate as possible, but no warranty or fitness is implied. The information provided is on an “as is” basis. The author and the publisher shall have neither liability nor responsibility to any person or entity with respect to any loss or damages arising from the information contained in this book or from the use of the CD or...