Edit

Excel.Interfaces.ChartPivotOptionsLoadOptions interface

  • Reference
Package:
excel

Encapsulates the options for the pivot chart.

Remarks

[ 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 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 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 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 ]