excel.interfaces.chartdatalabelsupdatedata.yml

### YamlMime:TSType
name: Excel.Interfaces.ChartDataLabelsUpdateData
uid: 'excel!Excel.Interfaces.ChartDataLabelsUpdateData:interface'
package: excel!
fullName: Excel.Interfaces.ChartDataLabelsUpdateData
summary: 'An interface for updating data on the ChartDataLabels object, for use in `chartDataLabels.set({ ... })`<!-- -->.'
remarks: ''
isPreview: false
isDeprecated: false
type: interface
properties:
  - name: autoText
    uid: 'excel!Excel.Interfaces.ChartDataLabelsUpdateData#autoText:member'
    package: excel!
    fullName: autoText
    summary: Specifies if data labels automatically generate appropriate text based on context.
    remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'autoText?: boolean;'
      return:
        type: boolean
  - name: format
    uid: 'excel!Excel.Interfaces.ChartDataLabelsUpdateData#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.ChartDataLabelFormatUpdateData;'
      return:
        type: '<xref uid="excel!Excel.Interfaces.ChartDataLabelFormatUpdateData:interface" />'
  - name: horizontalAlignment
    uid: 'excel!Excel.Interfaces.ChartDataLabelsUpdateData#horizontalAlignment:member'
    package: excel!
    fullName: horizontalAlignment
    summary: >-
      Specifies the horizontal alignment for chart data label. See `Excel.ChartTextHorizontalAlignment` for details.
      This property is valid only when the `TextOrientation` of data label is 0.
    remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: >-
        horizontalAlignment?: Excel.ChartTextHorizontalAlignment | "Center" | "Left" | "Right" | "Justify" |
        "Distributed";
      return:
        type: >-
          <xref uid="excel!Excel.ChartTextHorizontalAlignment:enum" /> | "Center" | "Left" | "Right" | "Justify" |
          "Distributed"
  - name: linkNumberFormat
    uid: 'excel!Excel.Interfaces.ChartDataLabelsUpdateData#linkNumberFormat:member'
    package: excel!
    fullName: linkNumberFormat
    summary: >-
      Specifies if the number format is linked to the cells. If `true`<!-- -->, the number format will change in the
      labels when it changes in the cells.
    remarks: '\[ [API set: ExcelApi 1.9](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'linkNumberFormat?: boolean;'
      return:
        type: boolean
  - name: numberFormat
    uid: 'excel!Excel.Interfaces.ChartDataLabelsUpdateData#numberFormat:member'
    package: excel!
    fullName: numberFormat
    summary: Specifies the format code for data labels.
    remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'numberFormat?: string;'
      return:
        type: string
  - name: position
    uid: 'excel!Excel.Interfaces.ChartDataLabelsUpdateData#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?: Excel.ChartDataLabelPosition | "Invalid" | "None" | "Center" | "InsideEnd" | "InsideBase" |
        "OutsideEnd" | "Left" | "Right" | "Top" | "Bottom" | "BestFit" | "Callout";
      return:
        type: >-
          <xref uid="excel!Excel.ChartDataLabelPosition:enum" /> | "Invalid" | "None" | "Center" | "InsideEnd" |
          "InsideBase" | "OutsideEnd" | "Left" | "Right" | "Top" | "Bottom" | "BestFit" | "Callout"
  - name: separator
    uid: 'excel!Excel.Interfaces.ChartDataLabelsUpdateData#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?: string;'
      return:
        type: string
  - name: showBubbleSize
    uid: 'excel!Excel.Interfaces.ChartDataLabelsUpdateData#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.ChartDataLabelsUpdateData#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.ChartDataLabelsUpdateData#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.ChartDataLabelsUpdateData#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.ChartDataLabelsUpdateData#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.ChartDataLabelsUpdateData#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
  - name: textOrientation
    uid: 'excel!Excel.Interfaces.ChartDataLabelsUpdateData#textOrientation:member'
    package: excel!
    fullName: textOrientation
    summary: >-
      Represents the angle to which the text is oriented for data labels. The value should either be an integer from -90
      to 90 or the integer 180 for vertically-oriented text.
    remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'textOrientation?: number;'
      return:
        type: number
  - name: verticalAlignment
    uid: 'excel!Excel.Interfaces.ChartDataLabelsUpdateData#verticalAlignment:member'
    package: excel!
    fullName: verticalAlignment
    summary: >-
      Represents the vertical alignment of chart data label. See `Excel.ChartTextVerticalAlignment` for details. This
      property is valid only when `TextOrientation` of the data label is -90, 90, or 180.
    remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'verticalAlignment?: Excel.ChartTextVerticalAlignment | "Center" | "Bottom" | "Top" | "Justify" | "Distributed";'
      return:
        type: >-
          <xref uid="excel!Excel.ChartTextVerticalAlignment:enum" /> | "Center" | "Bottom" | "Top" | "Justify" |
          "Distributed"