Excel PivotTables and Charts

Peter Aitken has been writing about computers and software for 20 years and has some 45 books as well as hundreds of magazine and web articles to his credit. He specializes in Excel, Visual Basic programming, and XML, but he has also ventured into such varied topics as personal finance, digital imaging, and camera phones. Peter also does technical writing in the medical and pharmaceutical fields and is a part--time faculty member at Duke University Medical Center. Visit his popular Spreadsheet Page at www.j--walk.com/ss.

Part I: Understanding PivotTables and Charts. Part II: Understanding Data Sources for PivotTables. Part III: Using PivotTable Tools and Formatting. Part: IV: Working with PivotTable Components. Part V: More About PivotTable Components. Part VI: Understanding and Using PivotCharts. Part VII: Using PivotTables with Multidimensional Data. Part VIII: Getting Hard Data from a PivotTable. Part IX: PivotTable Alternatives. Part X: Programming PivotTables with VBA. Appendix A: Troubleshooting PivotTables and PivotCharts. Appendix B: Excel Version Differences for PivotTables. Appendix C: An Excel Chart Primer. Index.