Table Of Content®
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:Use Excel 2013’s radically revamped charting and graphing tools to communicate more clearly, powerfully, and quickly… so you drive your message home, and get the decisions and actions you’re looking for! This book reveals data visualization techniques you won’t find anywhere else and shows y
