ExcelScript.ChartPivotOptions interface

Encapsulates the options for the pivot chart.

Methods

getShowAxisFieldButtons()

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.

getShowLegendFieldButtons()

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

getShowReportFilterFieldButtons()

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

getShowValueFieldButtons()

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

setShowAxisFieldButtons(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.

setShowLegendFieldButtons(showLegendFieldButtons)

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

setShowReportFilterFieldButtons(showReportFilterFieldButtons)

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

setShowValueFieldButtons(showValueFieldButtons)

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

Method Details

getShowAxisFieldButtons()

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.

getShowAxisFieldButtons(): boolean;

Returns

boolean

getShowLegendFieldButtons()

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

getShowLegendFieldButtons(): boolean;

Returns

boolean

getShowReportFilterFieldButtons()

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

getShowReportFilterFieldButtons(): boolean;

Returns

boolean

getShowValueFieldButtons()

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

getShowValueFieldButtons(): boolean;

Returns

boolean

setShowAxisFieldButtons(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.

setShowAxisFieldButtons(showAxisFieldButtons: boolean): void;

Parameters

showAxisFieldButtons

boolean

Returns

void

setShowLegendFieldButtons(showLegendFieldButtons)

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

setShowLegendFieldButtons(showLegendFieldButtons: boolean): void;

Parameters

showLegendFieldButtons

boolean

Returns

void

setShowReportFilterFieldButtons(showReportFilterFieldButtons)

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

setShowReportFilterFieldButtons(
            showReportFilterFieldButtons: boolean
        ): void;

Parameters

showReportFilterFieldButtons

boolean

Returns

void

setShowValueFieldButtons(showValueFieldButtons)

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

setShowValueFieldButtons(showValueFieldButtons: boolean): void;

Parameters

showValueFieldButtons

boolean

Returns

void