Represents a [[Series]] trendline.

See

[[Series.trendlineCollection]]

Hierarchy

Hierarchy (view full)

Constructors

Properties

$type: Type
$t: Type
nextHashCode: number

Accessors

  • get backward(): number
  • Specifies the number of periods or units by which the trendline extends backward.

    Returns number

  • set backward(a): void
  • Parameters

    • a: number

    Returns void

  • get chart(): WorksheetChart
  • Returns the owning chart (read-only)

    See

    [[owner]]

    Returns WorksheetChart

  • get forward(): number
  • Specifies the number of periods or units by which the trendline extends forward.

    Returns number

  • set forward(a): void
  • Parameters

    • a: number

    Returns void

  • get intercept(): number
  • Specifies the value axis intercept for the trendline.

    If this property is left unset, or assigned a value of null, the intercept is automatically determined by Excel.

    Returns number

  • set intercept(a): void
  • Parameters

    • a: number

    Returns void

  • get label(): TrendlineLabel
  • Returns or sets a [[TrendlineLabel]] instance which determines the text and appearance of the trendline label.

    This property is null by default, which prevents a label from appearing.

    To display a label for the trendline, assign a [[TrendlineLabel]] instance to this property.

    See

    [[TrendlineLabel]]

    Returns TrendlineLabel

  • set label(a): void
  • Parameters

    Returns void

  • get legendEntry(): LegendEntry
  • Returns a [[legendEntry]] instance which determines the appearance of this trendline's appearance in the [[WorksheetChart.legend]].

    See

    [[WorksheetChart.legend]]

    Returns LegendEntry

  • set legendEntry(a): void
  • Parameters

    Returns void

  • get line(): TrendlineLine
  • Returns or sets a [[TrendlineLine]] instance which controls the color and width of the trendline.

    To prevent the trendline from appearing in the chart, set this property to null.

    Returns TrendlineLine

  • set line(a): void
  • Parameters

    Returns void

  • get name(): string
  • Specifies the name of the trendline.

    Returns string

  • set name(a): void
  • Parameters

    • a: string

    Returns void

  • get order(): TrendlinePolynomialOrder
  • Specifies the order/degree of the polynomial function which defines the trendline. Applicable only when the [[trendlineType]] property is set to Polynomial.

    This property is only applicable when the [[trendlineType]] property is set to Polynomial.

    Trendlines support second-degree through sixth-degree polynomials.

    Returns TrendlinePolynomialOrder

  • set order(a): void
  • Parameters

    Returns void

  • get owner(): ChartObject
  • returns this object's owner. (read-only) The owner or null if this object is owned directly by the Chart

    See

    [[chart]]

    Returns ChartObject

  • get period(): number
  • Specifies the period for a moving-average trendline. Applicable only when the [[trendlineType]] property is set to MovingAverage.

    Returns number

  • set period(a): void
  • Parameters

    • a: number

    Returns void

  • get sheet(): Sheet
  • The owning sheet (read-only)

    Returns Sheet

  • get trendlineType(): TrendlineType
  • Specifies the type of trendline, i.e., linear, exponential, polynomial, etc.

    Returns TrendlineType

  • set trendlineType(a): void
  • Parameters

    Returns void

  • get workbook(): Workbook
  • The owning workbook (read-only)

    Returns Workbook

  • get worksheet(): Worksheet
  • The owning worksheet (read-only)

    Returns Worksheet

Methods

  • Parameters

    • other: any

    Returns boolean

  • Returns number

  • Returns Base

  • Parameters

    • item1: any
    • item2: any

    Returns number

  • Parameters

    • item1: any
    • item2: any

    Returns number

  • Parameters

    • item1: any
    • item2: any

    Returns boolean

  • Parameters

    • a: any
    • b: any

    Returns boolean

  • Parameters

    • obj: any

    Returns any[]

  • Parameters

    • obj: any

    Returns any[]

  • Parameters

    • obj: any

    Returns number

  • Parameters

    • a: any
    • b: any

    Returns boolean