Pivot Charts

Hi Marcia

Excel Pivot tables allow you to look at data in several dimensions. For example, sales by region, sales by sales rep, sales by product.

To create a Pivot table do the following:

Select a cell in the table holding the data from which you are creating a Pivot table

Select the Data menu and click Pivot table and Pivot chart report

Follow the steps in the Wizard; the computer sets the data Source automatically by picking up the range sorrounding the selected cell above. You then select where you want to place the pivot table.

Hope this helps

Carlos