Excel® 2013 Charts and Graphs

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
    3. PowerFrameworks.com
    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