excel.interfaces.chartdatalabelsloadoptions.yml

### YamlMime:TSType
name: Excel.Interfaces.ChartDataLabelsLoadOptions
uid: 'excel!Excel.Interfaces.ChartDataLabelsLoadOptions:interface'
package: excel!
fullName: Excel.Interfaces.ChartDataLabelsLoadOptions
summary: Represents a collection of all the data labels on a chart point.
remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
type: interface
properties:
  - name: $all
    uid: 'excel!Excel.Interfaces.ChartDataLabelsLoadOptions#$all:member'
    package: excel!
    fullName: $all
    summary: >-
      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`<!-- -->).
    remarks: ''
    isPreview: false
    isDeprecated: false
    syntax:
      content: '$all?: boolean;'
      return:
        type: boolean
  - name: format
    uid: 'excel!Excel.Interfaces.ChartDataLabelsLoadOptions#format:member'
    package: excel!
    fullName: format
    summary: 'Specifies the format of chart data labels, which includes fill and font formatting.'
    remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'format?: Excel.Interfaces.ChartDataLabelFormatLoadOptions;'
      return:
        type: '<xref uid="excel!Excel.Interfaces.ChartDataLabelFormatLoadOptions:interface" />'
  - name: position
    uid: 'excel!Excel.Interfaces.ChartDataLabelsLoadOptions#position:member'
    package: excel!
    fullName: position
    summary: Value that represents the position of the data label. See `Excel.ChartDataLabelPosition` for details.
    remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'position?: boolean;'
      return:
        type: boolean
  - name: separator
    uid: 'excel!Excel.Interfaces.ChartDataLabelsLoadOptions#separator:member'
    package: excel!
    fullName: separator
    summary: String representing the separator used for the data labels on a chart.
    remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'separator?: boolean;'
      return:
        type: boolean
  - name: showBubbleSize
    uid: 'excel!Excel.Interfaces.ChartDataLabelsLoadOptions#showBubbleSize:member'
    package: excel!
    fullName: showBubbleSize
    summary: Specifies if the data label bubble size is visible.
    remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'showBubbleSize?: boolean;'
      return:
        type: boolean
  - name: showCategoryName
    uid: 'excel!Excel.Interfaces.ChartDataLabelsLoadOptions#showCategoryName:member'
    package: excel!
    fullName: showCategoryName
    summary: Specifies if the data label category name is visible.
    remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'showCategoryName?: boolean;'
      return:
        type: boolean
  - name: showLegendKey
    uid: 'excel!Excel.Interfaces.ChartDataLabelsLoadOptions#showLegendKey:member'
    package: excel!
    fullName: showLegendKey
    summary: Specifies if the data label legend key is visible.
    remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'showLegendKey?: boolean;'
      return:
        type: boolean
  - name: showPercentage
    uid: 'excel!Excel.Interfaces.ChartDataLabelsLoadOptions#showPercentage:member'
    package: excel!
    fullName: showPercentage
    summary: Specifies if the data label percentage is visible.
    remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'showPercentage?: boolean;'
      return:
        type: boolean
  - name: showSeriesName
    uid: 'excel!Excel.Interfaces.ChartDataLabelsLoadOptions#showSeriesName:member'
    package: excel!
    fullName: showSeriesName
    summary: Specifies if the data label series name is visible.
    remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'showSeriesName?: boolean;'
      return:
        type: boolean
  - name: showValue
    uid: 'excel!Excel.Interfaces.ChartDataLabelsLoadOptions#showValue:member'
    package: excel!
    fullName: showValue
    summary: Specifies if the data label value is visible.
    remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'showValue?: boolean;'
      return:
        type: boolean