Just as you can create tables that you can reorganize on the fly to emphasize different aspects of your table and query data, you can also create dynamic charts, or PivotCharts, to summarize your data effectively. By changing the grouping order of the fields used to create your PivotChart, or by limiting which values are presented in the PivotChart, you answer specific questions posed by you and your colleagues. In addition to letting you change how your data appears in the chart, you can even change the type of chart you use to display your data!
Click the database object that contains your PivotChart data.
Drag fields that you want to provide values for the PivotChart’s category axis rows from the Chart Field List box to the Drop Category Fields Here area.
Drag fields that you want to provide values for the PivotChart’s data series from the Chart Field List box to the Drop Series Fields Here area.
Drag the fields that you want to provide values for the body of the PivotChart from the Chart Field List box to the Drop Data Fields Here area.