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.Table of contents
- Copyright
- About the Author
- Acknowledgments
- Introduction
-
I. Chart Basics
-
1. Introducing Excel Charts
- 1.1. What Is a Chart?
- 1.2. How Excel Handles Charts
- 1.3. Parts of a Chart
- 1.4. Basic Steps for Creating a Chart
-
1.5. Working with Charts
- 1.5.1. Moving and Resizing a Chart
- 1.5.2. Converting an Embedded Chart to a Chart Sheet
- 1.5.3. Copying a Chart
- 1.5.4. Deleting a Chart
- 1.5.5. Adding Chart Elements
- 1.5.6. Moving and Deleting Chart Elements
- 1.5.7. Formatting Chart Elements
- 1.5.8. Copying a Chart's Formatting
- 1.5.9. Renaming a Chart
- 1.5.10. Printing Charts
- 2. Understanding Chart Types
-
3. Working with Chart Series
- 3.1. Specifying the Data for Your Chart
- 3.2. Adding a New Series to a Chart
- 3.3. Deleting a Chart Series
- 3.4. Modifying the Data Range for a Chart Series
- 3.5. Understanding Series Names
- 3.6. Adjusting the Series Plot Order
- 3.7. Charting a Noncontiguous Range
- 3.8. Using Series on Different Sheets
- 3.9. Handling Missing Data
- 3.10. Controlling a Data Series by Hiding Data
- 3.11. Unlinking a Chart Series from Its Data Range
- 3.12. Working with Multiple Axes
-
4. Formatting and Customizing Charts
- 4.1. Chart Formatting Overview
- 4.2. Adjusting Fills and Borders: General Procedures
- 4.3. Formatting Chart Background Elements
- 4.4. Formatting Chart Series
- 4.5. Working with Chart Titles
- 4.6. Working with a Chart's Legend
- 4.7. Working with Chart Axes
- 4.8. Working with Gridlines
- 4.9. Working with Data Labels
- 4.10. Working with a Chart Data Table
- 4.11. Formatting 3-D Charts
- 5. Working with Trendlines and Error Bars
-
6. Working with Shapes and Other Graphics
-
6.1. Using Shapes
- 6.1.1. Inserting Shapes
- 6.1.2. Adding Text to a Shape
- 6.1.3. Formatting Shapes
- 6.1.4. Selecting Multiple Objects
- 6.1.5. Grouping Objects
- 6.1.6. Moving Shapes
- 6.1.7. Copying Objects
- 6.1.8. Changing the Stack Order of Objects
- 6.1.9. Aligning and Spacing Objects
- 6.1.10. Changing a Shape to a Different Shape
- 6.1.11. Reshaping Shapes
- 6.1.12. Changing the Shape Defaults
- 6.1.13. Printing Objects
- 6.2. Working with SmartArt
- 6.3. Using WordArt
- 6.4. Working with Other Graphic Types
- 6.5. A Gallery of Graphic Examples
-
6.1. Using Shapes
-
1. Introducing Excel Charts
-
II. Mastering Charts
-
7. Creating Interactive Charts
- 7.1. Introducing Interactive Charts
- 7.2. Hands–On: Creating a Self–Expanding Chart
- 7.3. Controlling a Series with a Scroll Bar
- 7.4. Specifying the Beginning and End Point for a Series
- 7.5. Specifying the First Point and Number of Points for a Series
- 7.6. Plotting the Last n Data Points in a Series
- 7.7. Plotting Every nth Data Point in a Series
- 7.8. Using Check Boxes to Select Series to Plot
- 7.9. Creating a Very Interactive Chart
-
8. Charting Techniques and Tricks
- 8.1. Adding Lines and Backgrounds to a Chart
- 8.2. Charts That Use a Single Data Point
- 8.3. Using a Dummy Axis
-
8.4. Column and Bar Chart Variations
- 8.4.1. Stacked Column Chart Variations
- 8.4.2. Creating a Step Chart
- 8.4.3. Varying Column Widths
- 8.4.4. Conditional Column Colors
- 8.4.5. Creating a Comparative Histogram
- 8.4.6. Creating Gantt Charts
- 8.4.7. Identifying the Maximum and Minimum Values in a Series
- 8.4.8. Shading between Two Series in a Line Chart
- 8.5. Creating a Timeline
- 8.6. Creating "Impossible" Charts by Stacking and Overlaying
- 8.7. Displaying Multiple Charts on a Chart Sheet
- 9. In-Cell Charting Techniques
-
10. Mathematical and Statistical Charting Techniques
- 10.1. Drawing a Circle with an XY Series
- 10.2. Connecting Scatter Chart Data Points to the Axes with Error Bars
- 10.3. Connecting XY Points to the Origin
- 10.4. Creating Frequency Distributions and Histograms
- 10.5. Plotting a Normal Curve
- 10.6. Plotting Z–Scores with Standard Deviation Bands
- 10.7. Calculating the Area under a Curve
- 10.8. Creating a Box Plot
- 10.9. Plotting Mathematical Functions
- 10.10. Creating a 3–D Scatter Plot
- 11. Using Pivot Charts
- 12. Avoiding Common Chart-Making Mistakes
- 13. Just for Fun
-
7. Creating Interactive Charts
-
III. Mastering Charts
- 14. VBA Overview and Basic Examples
- 15. Advanced VBA Examples
- 16. Working with Colors
- IV. Appendixes
- Wiley Publishing, Inc. End-User License Agreement
Product information
- Title: Excel® 2007 Charts
- Author(s):
- Release date: October 2007
- Publisher(s): Wiley
- ISBN: 9780470044001
You might also like
book
Excel® 2007 PivotTables and PivotCharts
Though many consumers know the basics of using Excel, few users understand the powerful capabilities of …
book
Create Dynamic Charts in Microsoft® Office Excel® 2007 and Beyond
Extend your Excel 2007 skills—and create more-powerful and compelling charts in less time. Guided by an …
book
Master Visually®: Excel® 2007
If you prefer instructions that show you how rather than tell you why, then this visual …
book
Microsoft® Office Excel® 2007 Step by Step
Experience learning made easy—and quickly teach yourself how to organize, analyze, and present data with Excel …