PivotOptions
PivotOptions class
Represents a complex type that specifies the pivot controls that appear on the chart
Methods
| Name | Description |
|---|---|
| getDropZoneCategories() | Specifies whether a control for each PivotTable field on the PivotTable row axis of the source PivotTable appears on the |
| getDropZoneData() | Specifies whether a control for each PivotTable field on the PivotTable data axis of the source PivotTable appears on th |
| getDropZoneFilter() | Specifies whether a control for each PivotTable field on the PivotTable page axis of the source PivotTable appears on th |
| getDropZoneSeries() | Specifies whether a control for each PivotTable field on the PivotTable column axis of the source PivotTable appears on |
| getDropZonesVisible() | Specifies whether any pivot controls can appear on the pivot chart. |
| getShowExpandCollapseFieldButtons() | |
| setDropZoneCategories() | Specifies whether a control for each PivotTable field on the PivotTable row axis of the source PivotTable appears on the |
| setDropZoneData() | Specifies whether a control for each PivotTable field on the PivotTable data axis of the source PivotTable appears on th |
| setDropZoneFilter() | Specifies whether a control for each PivotTable field on the PivotTable page axis of the source PivotTable appears on th |
| setDropZoneSeries() | Specifies whether a control for each PivotTable field on the PivotTable column axis of the source PivotTable appears on |
| setDropZonesVisible() | Specifies whether any pivot controls can appear on the pivot chart. |
| setShowExpandCollapseFieldButtons() |
getDropZoneCategories()
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.
getDropZoneData()
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.
getDropZoneFilter()
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.
getDropZoneSeries()
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.
getDropZonesVisible()
Specifies whether any pivot controls can appear on the pivot chart.
getShowExpandCollapseFieldButtons()
setDropZoneCategories()
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.
setDropZoneData()
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.
setDropZoneFilter()
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.
setDropZoneSeries()
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.
setDropZonesVisible()
Specifies whether any pivot controls can appear on the pivot chart.