Add a pivot chart

From a worksheet with lines you add a pivot chart.

This automatically creates a new pivot table (on which the chart is based).

You then format the pivot chart by specifying a scaling for the horizontal axis and determining which fields should be shown in the chart. This is default functionality of Microsoft Excel. For more information, please refer to the online Help (F1) of Microsoft Excel.

To add a pivot chart:

  1. Open the analysis.
  2. Go to: General / Output / Management / Analysis.
  3. Go to: the worksheet you want to use to create a pivot chart.
  4. Add a line graph:
    1. Go to the 'Add-ins' menu.
    2. Go to:Profit / Add pivot table.
  5. Select the Add pivot chart check box.
  6. If applicable, select the On separate worksheet check box. Otherwise the chart and pivot table will appear on the same tab.

    Dat_Draaigrafiek toevoegen - start

  7. Click on: OK.

    You now have a formatted pivot chart.

Directly to

  1. Pivot tables and charts
  2. Add a pivot table
  3. Add a pivot chart