Represents a [[Trendline]] label.

Constructors

Section titled "Constructors"

TrendlineLabel

new TrendlineLabel(): TrendlineLabel

Returns TrendlineLabel

Properties

Section titled "Properties"

$t

Section titled "$t" 
$t: Type

border

Section titled "border"

Inherited from: ChartLabelBase 

border: ChartBorder

displayEquation

Section titled "displayEquation" 
displayEquation: boolean

displayRSquared

Section titled "displayRSquared" 
displayRSquared: boolean

fill

Section titled "fill"

Inherited from: ChartLabelBase 

fill: ChartFillBase

horizontalOverflow

Section titled "horizontalOverflow"

Inherited from: ChartLabelBase 

horizontalOverflow: TextHorizontalOverflow

left

Section titled "left"

Inherited from: ChartLabelBase 

left: number

numberFormat

Section titled "numberFormat"

Inherited from: ChartLabelBase 

numberFormat: string

numberFormatLinked

Section titled "numberFormatLinked"

Inherited from: ChartLabelBase 

numberFormatLinked: boolean

position

Section titled "position"

Inherited from: ChartLabelBase 

position: ElementPosition

readingOrder

Section titled "readingOrder"

Inherited from: ChartLabelBase 

readingOrder: ReadingOrder

rotation

Section titled "rotation"

Inherited from: ChartLabelBase 

rotation: number

text

Section titled "text"

Inherited from: ChartLabelBase 

text: FormattedString

textDirection

Section titled "textDirection"

Inherited from: ChartLabelBase 

textDirection: TextDirection

top

Section titled "top"

Inherited from: ChartLabelBase 

top: number

verticalAlignment

Section titled "verticalAlignment"

Inherited from: ChartLabelBase 

verticalAlignment: VerticalTitleAlignment

verticalOverflow

Section titled "verticalOverflow"

Inherited from: ChartLabelBase 

verticalOverflow: TextVerticalOverflow

wrapText

Section titled "wrapText"

Inherited from: ChartLabelBase 

wrapText: boolean

Accessors

Section titled "Accessors"

chart

Section titled "chart"

Inherited from: ChartLabelBase

Returns the owning chart (read-only)

get chart(): WorksheetChart

Returns WorksheetChart

defaultFont

Section titled "defaultFont"

Inherited from: ChartLabelBase

Defines the font properties for each formatted run in the [[text]] that has no more specific setting. Read-only.

get defaultFont(): IWorkbookFont

Returns IWorkbookFont

formula

Section titled "formula"

Inherited from: ChartLabelBase

The formula used to get the text displayed within the text area. (read-only). To set this property call the SetFormula method. 

get formula(): Formula

Returns Formula

owner

Section titled "owner"

Inherited from: ChartLabelBase

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

get owner(): ChartObject

Returns ChartObject

sheet

Section titled "sheet"

Inherited from: ChartLabelBase

The owning sheet (read-only)

get sheet(): Sheet

Returns Sheet

workbook

Section titled "workbook"

Inherited from: ChartLabelBase

The owning workbook (read-only)

get workbook(): Workbook

Returns Workbook

worksheet

Section titled "worksheet"

Inherited from: ChartLabelBase

The owning worksheet (read-only)

get worksheet(): Worksheet

Returns Worksheet

Methods

Section titled "Methods"

setFormula

Section titled "setFormula"

Inherited from: ChartLabelBase

Assigns a new [[Formula]] to this instance.

setFormula(formula: string, cellReferenceMode: CellReferenceMode): void

Parameters

  • formula: string

    The string representation of the formula used to get the [[text]].
  • cellReferenceMode: CellReferenceMode

    A [[CellReferenceMode]] value which specifies whether the 'formula' parameter should be interpreted as an A1 or R1C1 expression. This parameter is optional and defaults to null, in which case the [[Workbook.cellReferenceMode]] property is used.

Returns void

staticInit

Section titled "staticInit" 
staticInit(): void

Returns void