Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Creating Pivot Charts

To create a pivot chart proceed as below:

  1. Click inside the pivot table that you want to present in your chart.

  2. Choose Insert – Chart or click in the Insert Chart icon in the main toolbar.

Office Calc automatically detects the pivot table and opens the pivot chart wizard.

  1. Select the Chart type for the data in the chart wizard.

The data range and the data series pages of the chart wizard are not enabled. They are controlled by the pivot table.

  1. Select the Chart Elements of the pivot chart in the wizard.

  2. Click OK to close the wizard and create the pivot chart.

Open file with example: