Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

Excel.Interfaces.ChartPivotOptionsUpdateData interface

Package:
excel

An interface for updating data on the ChartPivotOptions object, for use in chartPivotOptions.set({ ... }).

Remarks

Used by

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

Feedback

Was this page helpful?