## PivotOptions class

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

## Methods

| Name | Description |
| --- | --- |
| [getDropZoneCategories()](#getdropzonecategories) | Specifies whether a control for each PivotTable field on the PivotTable row axis of the source PivotTable appears on the |
| [getDropZoneData()](#getdropzonedata) | Specifies whether a control for each PivotTable field on the PivotTable data axis of the source PivotTable appears on th |
| [getDropZoneFilter()](#getdropzonefilter) | Specifies whether a control for each PivotTable field on the PivotTable page axis of the source PivotTable appears on th |
| [getDropZoneSeries()](#getdropzoneseries) | Specifies whether a control for each PivotTable field on the PivotTable column axis of the source PivotTable appears on  |
| [getDropZonesVisible()](#getdropzonesvisible) | Specifies whether any pivot controls can appear on the pivot chart. |
| [getShowExpandCollapseFieldButtons()](#getshowexpandcollapsefieldbuttons) |  |
| [setDropZoneCategories()](#setdropzonecategories) | Specifies whether a control for each PivotTable field on the PivotTable row axis of the source PivotTable appears on the |
| [setDropZoneData()](#setdropzonedata) | Specifies whether a control for each PivotTable field on the PivotTable data axis of the source PivotTable appears on th |
| [setDropZoneFilter()](#setdropzonefilter) | Specifies whether a control for each PivotTable field on the PivotTable page axis of the source PivotTable appears on th |
| [setDropZoneSeries()](#setdropzoneseries) | Specifies whether a control for each PivotTable field on the PivotTable column axis of the source PivotTable appears on  |
| [setDropZonesVisible()](#setdropzonesvisible) | Specifies whether any pivot controls can appear on the pivot chart. |
| [setShowExpandCollapseFieldButtons()](#setshowexpandcollapsefieldbuttons) |  |

### getDropZoneCategories() {#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() {#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() {#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() {#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() {#getdropzonesvisible}

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

### getShowExpandCollapseFieldButtons() {#getshowexpandcollapsefieldbuttons}

### setDropZoneCategories() {#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() {#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() {#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() {#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() {#setdropzonesvisible}

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

### setShowExpandCollapseFieldButtons() {#setshowexpandcollapsefieldbuttons}