® Excel 2013 Charts and Graphs Bill Jelen 800 East 96th Street, Indianapolis, Indiana 46240 USA Excel® 2013 Charts and Graphs Copyright © 2013 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 information contained herein. ISBN-13: 978-0-7897-4862-1 ISBN-10: 0-7897-4862-2 Library of Congress Cataloging-in-Publication data is on file. Printed in the United States of America First Printing: February 2013 Associate Publisher Greg Wiegand Executive Editor Loretta Yates Managing Editor Sandra Schroeder Development Editor Charlotte Kughen Project Editor Seth Kerney Copy Editor Barbara Hacha Indexer Ken Johnson Proofreader Kathy Ruiz Technical Editor Bob Umlas Publishing Coordinator Cindy Teeters Multimedia Developer Dan Scherf Interior Designer Anne Jones Cover Designer Anne Jones Page Layout Jake McFarland Trademarks All terms mentioned in this book that are known to be trademarks or service marks have been appropriately capitalized. Que Publishing 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. Warning and Disclaimer 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 programs accompanying it. Bulk Sales Que Publishing offers excellent discounts on this book when ordered in quantity for bulk purchases or special sales. For more information, please contact U.S. Corporate and Government Sales 1-800-382-3419 [email protected] For sales outside of the U.S., please contact International Sales [email protected] Contents at a Glance Introduction: Using Excel 2013 to Create Charts 1 Introducing Charts in Excel 2013 2 Customizing Charts 3 Creating Charts That Show Trends 4 Creating Charts That Show Differences 5 Creating Charts That Show Relationships 6 Creating Stock Analysis Charts 7 Advanced Chart Techniques 8 Creating Pivot Charts and Power View Dashboards 9 Using Sparklines, Data Visualizations, and Other Nonchart Methods 10 Presenting Excel Data on a Map 11 Using SmartArt Diagrams and Shapes 12 Exporting Charts for Use Outside of Excel 13 Using Excel VBA to Create Charts 14 Knowing When Someone Is Lying to You with a Chart A Charting References Index Contents Introduction: Using Excel 2013 to Create Charts Choosing the Right Chart Type Using Excel as Your Charting Canvas Topics Covered in This Book This Book’s Objectives Versions of Excel Conventions Used in This Book Special Elements in This Book Next Steps 1 Introducing Charts in Excel 2013 What’s New in Excel 2013 Charts Choosing Among the Three Ways to Create a Chart Creating a Chart from the Quick Analysis Icon Inserting a Recommended Chart Creating a Chart Using the Other Icons on the Insert Tab Creating a Chart Using Alt+F1 Changing the Chart Title Editing a Title in the Formula Bar Why Can’t Excel Pick Up the Title from the Worksheet? Assigning a Title from a Worksheet Cell Handling Special Situations Charting Noncontiguous Data Charting Nonsummarized Data Charting Differing Orders of Magnitude Using a Custom Combo Chart Reversing the Series and Categories in a Chart Changing the Data Sequence by Using Select Data Using the Charting Tools Introducing the Three Helper Icons Introducing the Format Task Pane Using Commands on the Design Tab Micromanaging Formatting Using the Format Tab Using Commands on the Home Tab Changing the Theme on the Page Layout tab Moving Charts Moving a Chart Within the Current Worksheet Moving a Chart to a Different Worksheet Next Steps 2 Customizing Charts Accessing Element Formatting Tools Identifying Chart Elements Recognizing Chart Labels and Axes Recognizing Analysis Elements Identifying Special Elements in a 3D Chart Formatting Chart Elements Moving the Legend Changing the Arrangement of a Legend Formatting Individual Legend Entries Adding Data Labels to a Chart Adding a Data Table to a Chart Formatting Axes Displaying and Formatting Gridlines Formatting the Plot Area and Chart Area Controlling 3D Rotation in a 3D Chart Forecasting with Trendlines Adding Drop Lines to a Line or Area Chart Adding Up/Down Bars to a Line Chart Showing Acceptable Tolerances by Using Error Bars Formatting a Series Formatting a Single Data Point
Description: