## PivotOptions class

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

## Properties

| Name | Type | Description |
| --- | --- | --- |
| [ShowExpandCollapseFieldButtons](#showexpandcollapsefieldbuttons) | boolean |  |
| [DropZoneFilter](#dropzonefilter) | boolean | Specifies whether a control for each PivotTable field on the PivotTable page axis of the source PivotTable appears on th |
| [DropZoneCategories](#dropzonecategories) | boolean | Specifies whether a control for each PivotTable field on the PivotTable row axis of the source PivotTable appears on the |
| [DropZoneData](#dropzonedata) | boolean | Specifies whether a control for each PivotTable field on the PivotTable data axis of the source PivotTable appears on th |
| [DropZoneSeries](#dropzoneseries) | boolean | Specifies whether a control for each PivotTable field on the PivotTable column axis of the source PivotTable appears on  |
| [DropZonesVisible](#dropzonesvisible) | boolean | Specifies whether any pivot controls can appear on the pivot chart. |

### PivotOptions.ShowExpandCollapseFieldButtons property {#showexpandcollapsefieldbuttons}

**Type:** boolean

### PivotOptions.DropZoneFilter property {#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.

**Type:** boolean

### PivotOptions.DropZoneCategories property {#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.

**Type:** boolean

### PivotOptions.DropZoneData property {#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.

**Type:** boolean

### PivotOptions.DropZoneSeries property {#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.

**Type:** boolean

### PivotOptions.DropZonesVisible property {#dropzonesvisible}

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

**Type:** boolean