Web Sites
Jon Peltier -- Pivot Tables, Pivot Charts, and Real Charts (TechTrax Article)
This article describes how to create pivot tables and pivot charts, and how to create normal charts from pivot tables.
Debra Dalgleish's Excel Tips and Techniques -- which includes these pages of Pivot Table-related topics:
Chip Pearson --
Introduction to Pivot Tables by Harald Staff
Brief intro to Pivot Tables, explains how data should be arranged, and
has code for updating the PT automatically.
Microsoft
-- PivotTable Reports 101
Good introduction to Pivot Tables.
Microsoft
-- 25 Easy PivotTable Reports
Sample file to download, and on-line instructions
Microsoft
-- Microsoft Excel Pivot Tables
A Business Software Tip by J. Carlton Collins, CPA
Daily Dose of Excel >> Creating a Simple Pivot Table
Dick Kusleika provides a detailed pictorial view into pivot tables.
Microsoft Knowledgebase Articles
Limits of PivotTables in Microsoft Excel (211517)
Outlines some of the limitations of Pivot Tables
Description of the limits of PivotTable reports in Excel (820742)
Outlines some of the limitations of Pivot Tables
HOW
TO: Optimize PivotTable Performance in Excel 2000 (273583)
Explains options in the PivotTable Wizard, and how they affect memory
usage, speed, and file size.
XL:
How to Use Grouping for Fields in a PivotTable (214259)
How to group dates, times and numbers in a Pivot Table
XL97:
Using PivotTable Calculated Fields and Calculated Items (161882)
Instructions and example for each feature
XL2000:
How to Create PivotTables from Multiple Consolidation Ranges (213947)
Describes how to create a PivotTable from multiple consolidation ranges,
with examples of how to create associated charts
| 
