PivotOptions

PivotOptions class

Represents a complex type that specifies the pivot controls that appear on the chart

class PivotOptions;

Properties

Property	Type	Description
dropZoneFilter	boolean	Specifies whether a control for each PivotTable field on the PivotTable page axis of the source PivotTable appears on the chart when dropZonesVisible is set to true.
dropZoneCategories	boolean	Specifies whether a control for each PivotTable field on the PivotTable row axis of the source PivotTable appears on the chart when dropZonesVisible is set to true.
dropZoneData	boolean	Specifies whether a control for each PivotTable field on the PivotTable data axis of the source PivotTable appears on the chart when dropZonesVisible is set to true.
dropZoneSeries	boolean	Specifies whether a control for each PivotTable field on the PivotTable column axis of the source PivotTable appears on the chart when dropZonesVisible is set to true.
dropZonesVisible	boolean	Specifies whether any pivot controls can appear on the pivot chart.

dropZoneFilter

Specifies whether a control for each PivotTable field on the PivotTable page axis of the source PivotTable appears on the chart when dropZonesVisible is set to true.

dropZoneFilter : boolean;

dropZoneCategories

Specifies whether a control for each PivotTable field on the PivotTable row axis of the source PivotTable appears on the chart when dropZonesVisible is set to true.

dropZoneCategories : boolean;

dropZoneData

Specifies whether a control for each PivotTable field on the PivotTable data axis of the source PivotTable appears on the chart when dropZonesVisible is set to true.

dropZoneData : boolean;

dropZoneSeries

Specifies whether a control for each PivotTable field on the PivotTable column axis of the source PivotTable appears on the chart when dropZonesVisible is set to true.

dropZoneSeries : boolean;

dropZonesVisible

Specifies whether any pivot controls can appear on the pivot chart.

dropZonesVisible : boolean;