Excel.Interfaces.ChartPivotOptionsLoadOptions interface

Encapsulates the options for the pivot chart.

[ API set: ExcelApi 1.9 ]

Properties

$all

Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: Range.format.fill.color).

showAxisFieldButtons

Specifies whether or not 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.

[ API set: ExcelApi 1.9 ]

showLegendFieldButtons

Specifies whether or not to display the legend field buttons on a PivotChart

[ API set: ExcelApi 1.9 ]

showReportFilterFieldButtons

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

[ API set: ExcelApi 1.9 ]

showValueFieldButtons

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

[ API set: ExcelApi 1.9 ]

Property Details

$all

Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: Range.format.fill.color).

$all?: boolean;

Property Value

boolean

showAxisFieldButtons

Specifies whether or not 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.

[ API set: ExcelApi 1.9 ]

showAxisFieldButtons?: boolean;

Property Value

boolean

showLegendFieldButtons

Specifies whether or not to display the legend field buttons on a PivotChart

[ API set: ExcelApi 1.9 ]

showLegendFieldButtons?: boolean;

Property Value

boolean

showReportFilterFieldButtons

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

[ API set: ExcelApi 1.9 ]

showReportFilterFieldButtons?: boolean;

Property Value

boolean

showValueFieldButtons

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

[ API set: ExcelApi 1.9 ]

showValueFieldButtons?: boolean;

Property Value

boolean