Analyzing Data with a PivotChart

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!

Step through the PivotChart Wizard

  1. Click the database object that contains your PivotChart data.

  2. Click the Create tab.

  3. Click PivotChart.

  4. 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.

  5. 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.

  6. 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.

  7. Click the Save button.

  8. Type a name for your PivotChart.

  9. Click OK.

    Step through the PivotChart Wizard

Change a PivotChart Chart Type

  1. Display the forms in your database.

  2. Double-click the form that contains your PivotChart.

  3. If necessary, click the Design tab.

  4. Click the Change Chart Type button.

  5. Click the Type tab.

  6. Click the new chart type.

  7. Click the subtype of the chart you want to create.

  8. Click the Close box.

    Change a PivotChart Chart Type
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset