PivotOptions
PivotOptions class
Represents a complex type that specifies the pivot controls that appear on the chart
Properties
| Name | Type | Description |
|---|---|---|
| ShowExpandCollapseFieldButtons | boolean | |
| DropZoneFilter | boolean | Specifies whether a control for each PivotTable field on the PivotTable page axis of the source PivotTable appears on th |
| DropZoneCategories | boolean | Specifies whether a control for each PivotTable field on the PivotTable row axis of the source PivotTable appears on the |
| DropZoneData | boolean | Specifies whether a control for each PivotTable field on the PivotTable data axis of the source PivotTable appears on th |
| DropZoneSeries | boolean | Specifies whether a control for each PivotTable field on the PivotTable column axis of the source PivotTable appears on |
| DropZonesVisible | boolean | Specifies whether any pivot controls can appear on the pivot chart. |
PivotOptions.ShowExpandCollapseFieldButtons property
Type: boolean
PivotOptions.DropZoneFilter property
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.
Type: boolean
PivotOptions.DropZoneCategories property
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.
Type: boolean
PivotOptions.DropZoneData property
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.
Type: boolean
PivotOptions.DropZoneSeries property
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.
Type: boolean
PivotOptions.DropZonesVisible property
Specifies whether any pivot controls can appear on the pivot chart.
Type: boolean