- 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
VBA Overview and Basic Examples
Advanced VBA Examples
Working with Colors
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.