You are previewing Excel® 2013 Charts and Graphs.
O'Reilly logo
Excel® 2013 Charts and Graphs

Book 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 you how to use Excel 2013 to create designer-quality charts and graphs that stand out from the crowd. It will help you make the most of new features ranging from Power View to Recommended Charts, and instantly share your insights with anyone, anywhere–even on the Web and social networks.

Learning advanced Excel techniques has never been easier. You’ll find simple, step-by-step instructions, real-world
examples and case studies, and more than a dozen YouTube videos, straight from MrExcel!

•      Create stunning data visualizations instantly with Excel 2013’s new Recommended Charts

•      Use charts to instantly reveal trends, differences, and relationships

•      Map your data with Excel 2013, MapPoint, and the new GeoFlow add-in

•      Quickly generate combo charts that once required complex, frustrating procedures

•      Use sparklines to imbue worksheets with more context and insight

•      Highlight and clarify the meaning of data with DataBars, color scales, icon sets, and other conditional formatting tools

•      Post charts to Facebook, Twitter, or LinkedIn, directly from Excel

•      Build stock charts that help you make smarter investments

•      Solve “non-standard” problems such as noncontiguous data or custom data sequences

•      Generate new charts automatically with Excel VBA

•      Uncover visual tricks that people use to lie with Excel

About MrExcel Library:  Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks
and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website, these
books will:

•      Dramatically increase your productivity–saving you 50 hours a year or more

•      Present proven, creative strategies for solving real-world problems

•      Show you how to get great results, no matter how much data you have

•      Help you avoid critical mistakes that even experienced users make

Table of Contents

  1. Title Page
  2. Copyright Page
  3. Contents at a Glance
  4. Contents
  5. Dedication
  6. About the Author
  7. Acknowledgments
  8. We Want to Hear from You!
  9. Reader Services
  10. Introduction: Using Excel 2013 to Create Charts
    1. Choosing the Right Chart Type
    2. Using Excel as Your Charting Canvas
    3. Topics Covered in This Book
    4. This Book’s Objectives
    5. Next Steps
  11. 1. Introducing Charts in Excel 2013
    1. What’s New in Excel 2013 Charts
    2. Choosing Among the Three Ways to Create a Chart
    3. Changing the Chart Title
    4. Handling Special Situations
    5. Using the Charting Tools
    6. Moving Charts
    7. Next Steps
  12. 2. Customizing Charts
    1. Accessing Element Formatting Tools
    2. Identifying Chart Elements
    3. Formatting Chart Elements
    4. Formatting a Series
    5. Changing the Theme Colors on the Page Layout Tab
    6. Storing Your Favorite Settings in a Chart Template
    7. Next Steps
  13. 3. Creating Charts That Show Trends
    1. Choosing a Chart Type
    2. Understanding Date-Based Axis Versus Category-Based Axis in Trend Charts
    3. Communicate Effectively with Charts
    4. Adding an Automatic Trendline to a Chart
    5. Showing a Trend of Monthly Sales and Year-to-Date Sales
    6. Understanding the Shortcomings of Stacked Column Charts
    7. Shortcomings of Showing Many Trends on a Single Chart
    8. Next Steps
  14. 4. Creating Charts That Show Differences
    1. Comparing Entities
    2. Using Bar Charts to Illustrate Item Comparisons
    3. Showing Component Comparisons
    4. Using a Waterfall Chart to Tell the Story of Component Decomposition
    5. Next Steps
  15. 5. Creating Charts That Show Relationships
    1. Using Scatter Charts to Plot Pairs of Data Points
    2. Using Charts to Show Relationships
    3. Using Surface Charts to Show Contrast
    4. Next Steps
  16. 6. Creating Stock Analysis Charts
    1. Overview of Stock Charts
    2. Obtaining Stock Data to Chart
    3. Creating a Line Chart to Show Closing Prices
    4. Creating OHLC Charts
    5. Creating Candlestick Charts
    6. Next Steps
  17. 7. Advanced Chart Techniques
    1. Mixing Two Chart Types on a Single Chart
    2. Moving Charts from One Worksheet to Another
    3. Making Columns or Bars Float
    4. Using a Rogue XY Series for Arbitrary Gridlines
    5. Showing Several Charts on One Chart by Using a Rogue XY Series
    6. Creating Bullet Charts in Excel 2013
    7. Creating a Thermometer Chart
    8. Creating a Benchmark Chart
    9. Creating a Delta Chart
    10. Next Steps
  18. 8. Creating Pivot Charts and Power View Dashboards
    1. Creating a PivotChart Using Recommended Charts
    2. Using PowerPivot and Power View
    3. Next Steps
  19. 9. Using Sparklines, Data Visualizations, and Other Nonchart Methods
    1. Fitting a Chart into the Size of a Cell with Sparklines
    2. Using Data Bars to Create In-Cell Bar Charts
    3. Using Color Scales to Highlight Extremes
    4. Using Icon Sets to Segregate Data
    5. Creating a Chart Using Conditional Formatting in Worksheet Cells
    6. Creating a Chart Using the REPT Function
    7. Next Steps
  20. 10. Presenting Excel Data on a Map
    1. Plotting Data Geographically
    2. Importing Data to MapPoint
    3. Creating a Map in Power View
    4. Creating a Map in GeoFlow
    5. Next Steps
  21. 11. Using SmartArt Diagrams and Shapes
    1. Using SmartArt
    2. Choosing the Right Layout for Your Message
    3. Exploring Business Charts That Use SmartArt Graphics
    4. Using Shapes to Display Cell Contents
    5. Using WordArt for Interesting Titles and Headlines
    6. Next Steps
  22. 12. Exporting Charts for Use Outside of Excel
    1. Presenting Excel Charts in PowerPoint or Word
    2. Presenting Charts on the Web
    3. Exporting Charts to Graphics Using VBA
    4. Converting to XPS or PDF
    5. Next Steps
  23. 13. Using Excel VBA to Create Charts
    1. Introducing VBA
    2. Learning Tricks of the VBA Trade
    3. Understanding Backward Compatibility
    4. Referencing Charts and Chart Objects in VBA Code
    5. Understanding the Global Settings
    6. Creating a Chart in Various Excel Versions
    7. Customizing a Chart
    8. Using SetElement to Emulate Changes from the Plus Icon
    9. Formatting a Data Series
    10. Creating a Combo Chart
    11. Creating Advanced Charts
    12. Exporting a Chart as a Graphic
    13. Creating Pivot Charts
    14. Creating Data Bars with VBA
    15. Creating Sparklines with VBA
    16. Next Steps
  24. 14. Knowing When Someone Is Lying to You with a Chart
    1. Lying with Perspective
    2. Lying with Shrinking Charts
    3. Lying with Scale
    4. Lying Because Excel Will Not Cooperate
    5. Avoiding Stacked Surface Charts
    6. Asserting a Trend from Two Data Points
    7. Deliberately Using Charts to Lie
    8. Charting Something Else When Numbers Are Too Bad
    9. Stretching Pictographs
    10. Next Steps
  25. A. Charting References
    1. Other Charting Resources
    2. Gene Zelazny: The Guru of Business Charting
    4. Books by Edward Tufte
    5. Websites with Charting Tutorials
    6. Interactive Training
    7. Live Training
    8. Blogs About Charting
    9. Visual Design Stores
    10. Professional Chart Designers
    11. Charting Utilities and Products
  26. Index
  27. Ad Pages