Excel 2007 Charts

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.

  Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

CONTENTS:

Introduction.

  Part I: Chart Basics.

  
Chapter 1: Introducing Excel Charts.

  
Chapter 2: Understanding Chart Types.

  
Chapter 3: Working with Chart Series.

  
Chapter 4: Formatting and Customizing Charts.

  
Chapter 5: Working with Trendlines and Error Bars.

  
Chapter 6: Working with Shapes and Other Graphics.

  Part II: Mastering Charts.

  
Chapter 7: Creating Interactive Charts.

  
Chapter 8: Charting Techniques and Tricks.

  
Chapter 9: In-Cell Charting Techniques.

  
Chapter 10: Mathematical and Statistical Charting Techniques.

  
Chapter 11: Using Pivot Charts.

  
Chapter 12: Avoiding Common Chart-Making Mistakes.

  
Chapter 13: Just for Fun.

  Part III: Mastering Charts.

  
Chapter 14: VBA Overview and Basic Examples.

  
Chapter 15: Advanced VBA Examples.

  
Chapter 16: Working with Colors.

  Part IV: Appendixes.

  
Appendix A: What’s on the CD-ROM?

  
Appendix B: Other Charting Resources.

  
Index.

  
End-User License Agreement.