PivotOptions
PivotOptions class
Represents a complex type that specifies the pivot controls that appear on the chart
class PivotOptions;
Properties
| Property | Type | Description |
|---|---|---|
| showExpandCollapseFieldButtons | boolean | Gets or sets a value indicating whether to show expand/collapse field buttons |
| 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. |
showExpandCollapseFieldButtons
Gets or sets a value indicating whether to show expand/collapse field buttons
showExpandCollapseFieldButtons : boolean;
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;