Excel.Interfaces.ChartPivotOptionsData interface

Package:

excel

An interface describing the data returned by calling chartPivotOptions.toJSON().

Properties

showAxisFieldButtons	Specifies whether to display the axis field buttons on a PivotChart. The showAxisFieldButtons property corresponds to the "Show Axis Field Buttons" command on the "Field Buttons" drop-down list of the "Analyze" tab, which is available when a PivotChart is selected.
showLegendFieldButtons	Specifies whether to display the legend field buttons on a PivotChart.
showReportFilterFieldButtons	Specifies whether to display the report filter field buttons on a PivotChart.
showValueFieldButtons	Specifies whether to display the show value field buttons on a PivotChart.

Property Details

showAxisFieldButtons

Specifies whether to display the axis field buttons on a PivotChart. The showAxisFieldButtons property corresponds to the "Show Axis Field Buttons" command on the "Field Buttons" drop-down list of the "Analyze" tab, which is available when a PivotChart is selected.

showAxisFieldButtons?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

showLegendFieldButtons

Specifies whether to display the legend field buttons on a PivotChart.

showLegendFieldButtons?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

showReportFilterFieldButtons

Specifies whether to display the report filter field buttons on a PivotChart.

showReportFilterFieldButtons?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

showValueFieldButtons

Specifies whether to display the show value field buttons on a PivotChart.

showValueFieldButtons?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]