Excel.Interfaces.ChartPivotOptionsLoadOptions interface

Package:

excel

Encapsulates the options for the pivot chart.

Remarks

[ API set: ExcelApi 1.9 ]

Properties

$all	Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).
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

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).

$all?: boolean;

Property Value

boolean

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 ]