## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

No credit card required

## Book Description

Excel, the top number-crunching tool, now offers a vastly improved charting function to help you give those numbers dimension and relativity. John Walkenbach, a.k.a. Mr. Spreadsheet, clearly explains all these charting features and shows you how to choose the right chart for your needs. You’ll learn to modify data within the chart, deal with missing data, format your chart, use trend lines, construct “impossible” charts, create charts from pivot tables, dress them up with graphics, and more.

These links have been provided by the publisher.

3. Acknowledgments
4. Introduction
1. What You Should Know
2. What You Should Have
3. Conventions Used in This Book
4. How This Book Is Organized
5. How to Use This Book
6. About the Power Utility Pak Offer
7. Reach Out
5. I. Chart Basics
1. 1. Introducing Excel Charts
1. 1.1. What Is a Chart?
2. 1.2. How Excel Handles Charts
3. 1.3. Parts of a Chart
4. 1.4. Basic Steps for Creating a Chart
5. 1.5. Working with Charts
2. 2. Understanding Chart Types
1. 2.1. Conveying a Message with a Chart
2. 2.2. Choosing a Chart Type
3. 2.3. Excel's Chart Types
4. 2.4. Creating Combination Charts
5. 2.5. Creating and Using Chart Templates
3. 3. Working with Chart Series
1. 3.1. Specifying the Data for Your Chart
2. 3.2. Adding a New Series to a Chart
3. 3.3. Deleting a Chart Series
4. 3.4. Modifying the Data Range for a Chart Series
5. 3.5. Understanding Series Names
6. 3.6. Adjusting the Series Plot Order
7. 3.7. Charting a Noncontiguous Range
8. 3.8. Using Series on Different Sheets
9. 3.9. Handling Missing Data
10. 3.10. Controlling a Data Series by Hiding Data
11. 3.11. Unlinking a Chart Series from Its Data Range
12. 3.12. Working with Multiple Axes
4. 4. Formatting and Customizing Charts
1. 4.1. Chart Formatting Overview
2. 4.2. Adjusting Fills and Borders: General Procedures
3. 4.3. Formatting Chart Background Elements
4. 4.4. Formatting Chart Series
5. 4.5. Working with Chart Titles
6. 4.6. Working with a Chart's Legend
7. 4.7. Working with Chart Axes
8. 4.8. Working with Gridlines
9. 4.9. Working with Data Labels
10. 4.10. Working with a Chart Data Table
11. 4.11. Formatting 3-D Charts
5. 5. Working with Trendlines and Error Bars
1. 5.1. Working with Trendlines
2. 5.2. Linear Trendlines
3. 5.3. Nonlinear Trendlines
4. 5.4. Displaying a Moving Average
5. 5.5. Using Error Bars in a Chart Series
6. 5.6. Other Series Enhancements
6. 6. Working with Shapes and Other Graphics
1. 6.1. Using Shapes
2. 6.2. Working with SmartArt
3. 6.3. Using WordArt
4. 6.4. Working with Other Graphic Types
5. 6.5. A Gallery of Graphic Examples
6. II. Mastering Charts
1. 7. Creating Interactive Charts
1. 7.1. Introducing Interactive Charts
2. 7.2. Hands–On: Creating a Self–Expanding Chart
3. 7.3. Controlling a Series with a Scroll Bar
4. 7.4. Specifying the Beginning and End Point for a Series
5. 7.5. Specifying the First Point and Number of Points for a Series
6. 7.6. Plotting the Last n Data Points in a Series
7. 7.7. Plotting Every nth Data Point in a Series
8. 7.8. Using Check Boxes to Select Series to Plot
9. 7.9. Creating a Very Interactive Chart
2. 8. Charting Techniques and Tricks
1. 8.1. Adding Lines and Backgrounds to a Chart
2. 8.2. Charts That Use a Single Data Point
3. 8.3. Using a Dummy Axis
4. 8.4. Column and Bar Chart Variations
5. 8.5. Creating a Timeline
6. 8.6. Creating "Impossible" Charts by Stacking and Overlaying
7. 8.7. Displaying Multiple Charts on a Chart Sheet
3. 9. In-Cell Charting Techniques
1. 9.1. Visualizing Data with Conditional Formatting
2. 9.2. Plotting Data without a Chart
3. 9.3. Creating Sparkline Charts
4. 10. Mathematical and Statistical Charting Techniques
1. 10.1. Drawing a Circle with an XY Series
2. 10.2. Connecting Scatter Chart Data Points to the Axes with Error Bars
3. 10.3. Connecting XY Points to the Origin
4. 10.4. Creating Frequency Distributions and Histograms
5. 10.5. Plotting a Normal Curve
6. 10.6. Plotting Z–Scores with Standard Deviation Bands
7. 10.7. Calculating the Area under a Curve
8. 10.8. Creating a Box Plot
9. 10.9. Plotting Mathematical Functions
10. 10.10. Creating a 3–D Scatter Plot
5. 11. Using Pivot Charts
1. 11.1. What Is a Pivot Table?
2. 11.2. Creating a Pivot Table
3. 11.3. Working with Pivot Charts
4. 11.4. Pivot Chart Banking Examples
5. 11.5. More Pivot Chart Examples
6. 12. Avoiding Common Chart-Making Mistakes
2. 12.2. Chart Accuracy
3. 12.3. Problems with Chart Type Selection
4. 12.4. Chart Complexity
5. 12.5. Chart Style
6. 12.6. A Chart Maker's Checklist
7. 13. Just for Fun
1. 13.1. Animating Stuff
2. 13.2. Fun with Trigonometry
3. 13.3. Chart Art
4. 13.4. Scatter Chart Drawings
5. 13.5. An Analog Clock Chart
6. 13.6. Roll the Dice
7. 13.7. Horse Race Chart
8. 13.8. Using Clip Art
7. III. Mastering Charts
1. 14. VBA Overview and Basic Examples
1. 14.1. VBA in a Nutshell
2. 14.2. The Macro Recorder and Charts
3. 14.3. The Chart Object Model
4. 14.4. Simple Chart Macros
5. 14.5. Counting and Looping through Charts
6. 14.6. Setting Axis Values
7. 14.7. Sizing and Aligning Charts
1. 15.1. Creating Charts with VBA
2. 15.2. Using VBA to Apply Chart Formatting
3. 15.3. Applying Data Labels
4. 15.4. Exporting Charts as GIF Files
5. 15.5. Creating a Scrolling Chart
6. 15.6. Creating a Word Cloud
7. 15.7. Determining the Ranges Used by a Chart
8. 15.8. Event Procedure Examples
3. 16. Working with Colors
1. 16.1. About Excel 2007 Colors
2. 16.2. Specifying Colors
3. 16.3. Understanding Grayscale
4. 16.4. Experimenting with Colors
5. 16.5. Understanding Document Themes
6. 16.6. Working with Shape Objects
7. 16.7. Modifying Chart Colors
8. IV. Appendixes
1. A. What's on the CD–ROM?
1. System Requirements
2. Using the CD
3. What's on the CD
4. Troubleshooting
5. Customer Care
2. B. Other Charting Resources
1. Excel's Help System
2. Microsoft Technical Support
3. Internet Newsgroups
4. Internet Web Sites
5. Excel Charting Add–Ins and Enhancements
9. Wiley Publishing, Inc. End-User License Agreement