excel.interfaces.charttrendlinedata.yml

### YamlMime:TSType
name: Excel.Interfaces.ChartTrendlineData
uid: 'excel!Excel.Interfaces.ChartTrendlineData:interface'
package: excel!
fullName: Excel.Interfaces.ChartTrendlineData
summary: An interface describing the data returned by calling `chartTrendline.toJSON()`<!-- -->.
remarks: ''
isPreview: false
isDeprecated: false
type: interface
properties:
  - name: backwardPeriod
    uid: 'excel!Excel.Interfaces.ChartTrendlineData#backwardPeriod:member'
    package: excel!
    fullName: backwardPeriod
    summary: Represents the number of periods that the trendline extends backward.
    remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'backwardPeriod?: number;'
      return:
        type: number
  - name: format
    uid: 'excel!Excel.Interfaces.ChartTrendlineData#format:member'
    package: excel!
    fullName: format
    summary: Represents the formatting of a chart trendline.
    remarks: '\[ [API set: ExcelApi 1.7](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'format?: Excel.Interfaces.ChartTrendlineFormatData;'
      return:
        type: '<xref uid="excel!Excel.Interfaces.ChartTrendlineFormatData:interface" />'
  - name: forwardPeriod
    uid: 'excel!Excel.Interfaces.ChartTrendlineData#forwardPeriod:member'
    package: excel!
    fullName: forwardPeriod
    summary: Represents the number of periods that the trendline extends forward.
    remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'forwardPeriod?: number;'
      return:
        type: number
  - name: intercept
    uid: 'excel!Excel.Interfaces.ChartTrendlineData#intercept:member'
    package: excel!
    fullName: intercept
    summary: >-
      Represents the intercept value of the trendline. Can be set to a numeric value or an empty string (for automatic
      values). The returned value is always a number.
    remarks: '\[ [API set: ExcelApi 1.7](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'intercept?: any;'
      return:
        type: any
  - name: label
    uid: 'excel!Excel.Interfaces.ChartTrendlineData#label:member'
    package: excel!
    fullName: label
    summary: Represents the label of a chart trendline.
    remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'label?: Excel.Interfaces.ChartTrendlineLabelData;'
      return:
        type: '<xref uid="excel!Excel.Interfaces.ChartTrendlineLabelData:interface" />'
  - name: movingAveragePeriod
    uid: 'excel!Excel.Interfaces.ChartTrendlineData#movingAveragePeriod:member'
    package: excel!
    fullName: movingAveragePeriod
    summary: Represents the period of a chart trendline. Only applicable to trendlines with the type `MovingAverage`<!-- -->.
    remarks: '\[ [API set: ExcelApi 1.7](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'movingAveragePeriod?: number;'
      return:
        type: number
  - name: name
    uid: 'excel!Excel.Interfaces.ChartTrendlineData#name:member'
    package: excel!
    fullName: name
    summary: >-
      Represents the name of the trendline. Can be set to a string value, a `null` value represents automatic values.
      The returned value is always a string
    remarks: '\[ [API set: ExcelApi 1.7](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'name?: string;'
      return:
        type: string
  - name: polynomialOrder
    uid: 'excel!Excel.Interfaces.ChartTrendlineData#polynomialOrder:member'
    package: excel!
    fullName: polynomialOrder
    summary: Represents the order of a chart trendline. Only applicable to trendlines with the type `Polynomial`<!-- -->.
    remarks: '\[ [API set: ExcelApi 1.7](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'polynomialOrder?: number;'
      return:
        type: number
  - name: showEquation
    uid: 'excel!Excel.Interfaces.ChartTrendlineData#showEquation:member'
    package: excel!
    fullName: showEquation
    summary: True if the equation for the trendline is displayed on the chart.
    remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'showEquation?: boolean;'
      return:
        type: boolean
  - name: showRSquared
    uid: 'excel!Excel.Interfaces.ChartTrendlineData#showRSquared:member'
    package: excel!
    fullName: showRSquared
    summary: True if the r-squared value for the trendline is displayed on the chart.
    remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'showRSquared?: boolean;'
      return:
        type: boolean
  - name: type
    uid: 'excel!Excel.Interfaces.ChartTrendlineData#type:member'
    package: excel!
    fullName: type
    summary: Represents the type of a chart trendline.
    remarks: '\[ [API set: ExcelApi 1.7](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: >-
        type?: Excel.ChartTrendlineType | "Linear" | "Exponential" | "Logarithmic" | "MovingAverage" | "Polynomial" |
        "Power";
      return:
        type: >-
          <xref uid="excel!Excel.ChartTrendlineType:enum" /> | "Linear" | "Exponential" | "Logarithmic" |
          "MovingAverage" | "Polynomial" | "Power"