Creating Your First Pivot Chart in Excel 2007:-


1. Pivot tables are the most powerful feature in Excel.

2. A pivot table allows you to summarize a million records of transactional data in Excel with a few mouse clicks.

3. A pivot chart is an extension of the pivot table concept. While building a summary of your data using a pivot table, you can specify that the results be presented in a chart

4. With the resulting chart, you can quickly filter to see a summary of records that match current criteria. You can also replicate a pivot chart so that you have one chart for each region, product, customer, and so on.