Create PivotChart reports to view data in Excel

Applies to
Microsoft Excel 2000

Overview: What can you do with a PivotChart report?

New to Microsoft Excel 2000 is the PivotChart® report. The PivotChart report gives you the eye-catching appeal and benefits of a graphic illustration of data while also giving you the dynamic flexibility and different views of data that you find in a PivotTable® report. For example, you might create a chart that shows the sum of sales for each salesperson by product in all regions over all recorded years. A chart like this might have a Year field and Region field set as page fields, Salesperson as a Series field, and product Type as a category field. Now, let's say you want to see the sales of products by each year. Simply drag the Year field to the category axis on the chart, and the category axis displays the products sold during each year.

If you want to see products sold by year for only two of four salespeople, just click the arrow on the Salesperson field, and clear the checkboxes of the salesperson names you don't want to see.

Animated example of dragging fields in a PivotChart report

Finally, you want to see the sum of sales of the two salespeople per year broken down by product. Simply move the Type field from the Category area to the Series area; and then move the Salesperson field to the Category area.

Animated example of dragging fields in a PivotChart report

Create a PivotChart report

Use the PivotTable and PivotChart Report Wizard to create a PivotChart report. In the wizard, you can specify the type of source data you want to use, set options for how the data is used, and lay out the chart elements. You can also lay out the chart elements on the chart sheet itself.

Associated PivotTable report

When you use the wizard, Excel creates an associated PivotTable report in the location you specify (on the existing worksheet or in a new worksheet in the same workbook) if you did not start with an existing PivotTable report. A PivotTable report is an interactive table that you can use to quickly summarize large amounts of data. You can rotate its rows and columns to see different summaries of the source data, filter the data by displaying different pages, or display the details for areas of interest. The PivotTable report uses the layout that you specify for the PivotChart report: Category fields in the chart are row fields in the table, and series fields in the chart are column fields in the table. When you change a PivotChart report, the PivotTable report changes, and vice versa.

Source data

You can use a Microsoft Excel list or database, an existing PivotTable report, an external data source (such as a Microsoft Access database, SQL Server database, OLAP Server database, or Oracle database) or consolidated data as sources of information for your PivotChart report.

More information

For more information about PivotChart reports, type PivotChart report in the Office Assistant or on the Answer Wizard tab in the Excel Help window, and then click Search.