Display multiple charts in PivotChart view

You can create multiple charts in the same PivotChart view to make it easy to compare different aspects of your data. The following example shows multiple charts that compare sales data by using individual charts for each salesperson. The charts in the example also use the same scale, which is optional.

Multiple charts in one chart workspace

  1. Open a datasheet or form in PivotChart view.
  2. On the PivotChart toolbar, click Multiple Plots Chart Multiple Plots .

  3. If you want to use the same axis scale for all charts, click Multiple Plots Unified Scale .

  4. On the PivotChart toolbar, click Field List , and then use the scroll bars and the expand indicators (Plus box and Minus box boxes) to find the field you want to add to the chart.
  5. Click the field and drag it to the drop area on the chart that says Drop MultiChart Fields Here. You can add multiple fields to the MultiChart area.

  6. If you want to specify the layout of the multiple charts, click Properties on the PivotChart toolbar, and then click the General tab.

  7. Make sure Chart Workspace is selected in the Select box.

  8. Under Chart workspace, click Horizontal or Vertical in the Chart layout list.

    If you select Automatic, the charts will be displayed horizontally or vertically depending on the size and shape of the workspace.

  9. If you want to limit the number of charts across and down the chart workspace, type in the Maximum charts per row/col box the maximum number of charts you want displayed.