excel.interfaces.chartpivotoptionsloadoptions.yml

### YamlMime:TSType
name: Excel.Interfaces.ChartPivotOptionsLoadOptions
uid: 'excel!Excel.Interfaces.ChartPivotOptionsLoadOptions:interface'
package: excel!
fullName: Excel.Interfaces.ChartPivotOptionsLoadOptions
summary: Encapsulates the options for the pivot chart.
remarks: '\[ [API set: ExcelApi 1.9](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
type: interface
properties:
  - name: $all
    uid: 'excel!Excel.Interfaces.ChartPivotOptionsLoadOptions#$all:member'
    package: excel!
    fullName: $all
    summary: >-
      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`<!-- -->).
    remarks: ''
    isPreview: false
    isDeprecated: false
    syntax:
      content: '$all?: boolean;'
      return:
        type: boolean
  - name: showAxisFieldButtons
    uid: 'excel!Excel.Interfaces.ChartPivotOptionsLoadOptions#showAxisFieldButtons:member'
    package: excel!
    fullName: showAxisFieldButtons
    summary: >-
      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.
    remarks: '\[ [API set: ExcelApi 1.9](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'showAxisFieldButtons?: boolean;'
      return:
        type: boolean
  - name: showLegendFieldButtons
    uid: 'excel!Excel.Interfaces.ChartPivotOptionsLoadOptions#showLegendFieldButtons:member'
    package: excel!
    fullName: showLegendFieldButtons
    summary: Specifies whether to display the legend field buttons on a PivotChart.
    remarks: '\[ [API set: ExcelApi 1.9](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'showLegendFieldButtons?: boolean;'
      return:
        type: boolean
  - name: showReportFilterFieldButtons
    uid: 'excel!Excel.Interfaces.ChartPivotOptionsLoadOptions#showReportFilterFieldButtons:member'
    package: excel!
    fullName: showReportFilterFieldButtons
    summary: Specifies whether to display the report filter field buttons on a PivotChart.
    remarks: '\[ [API set: ExcelApi 1.9](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'showReportFilterFieldButtons?: boolean;'
      return:
        type: boolean
  - name: showValueFieldButtons
    uid: 'excel!Excel.Interfaces.ChartPivotOptionsLoadOptions#showValueFieldButtons:member'
    package: excel!
    fullName: showValueFieldButtons
    summary: Specifies whether to display the show value field buttons on a PivotChart.
    remarks: '\[ [API set: ExcelApi 1.9](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'showValueFieldButtons?: boolean;'
      return:
        type: boolean