If you wish to create a a Pivot Table and Pivot Chart in Excel, then this detailed article will guide you through the entire process.

The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. All you need is one common, unique field. Here's how to set it up with multiple spreadsheets.

Excel will add a filter above the pivot table. From the dropdown, choose Northeast, and watch the pivot table update accordingly. Figure F You can drag any field in the pivot table to the filters ...