Represents the title of a [[WorksheetChart]] or [[Axis]].

Constructors

Section titled "Constructors"

ChartTitle 

new ChartTitle(): ChartTitle

Returns ChartTitle

Properties

Section titled "Properties"

$t

Section titled "$t" 
$t: Type

Accessors

Section titled "Accessors"

border

Section titled "border"

Inherited from: ChartTextAreaBase

Determines the appearance of the border drawn around the text area, as well as whether a border appears.

 
get border(): ChartBorder

Returns ChartBorder 

set border(a: ChartBorder): void

Parameters

Returns void

chart

Section titled "chart"

Inherited from: ChartTextAreaBase

Returns the owning chart (read-only)

 
get chart(): WorksheetChart

Returns WorksheetChart

defaultFont

Section titled "defaultFont"

Inherited from: ChartTextAreaBase

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

 
get defaultFont(): IWorkbookFont

Returns IWorkbookFont

fill

Section titled "fill"

Inherited from: ChartTextAreaBase

Returns or sets a [[ChartFillBase]] derived object which defines the fill properties for the text area.

 
get fill(): ChartFillBase

Returns ChartFillBase 

set fill(a: ChartFillBase): void

Parameters

Returns void

formula

Section titled "formula"

Inherited from: ChartTextAreaBase

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

horizontalOverflow

Section titled "horizontalOverflow"

Inherited from: ChartTextAreaBase

Determines whether text is allowed to continue horizontally outside the bounds of the containing element.

 
get horizontalOverflow(): TextHorizontalOverflow

Returns TextHorizontalOverflow 

set horizontalOverflow(a: TextHorizontalOverflow): void

Parameters

Returns void

left

Section titled "left"

Inherited from: ChartTextAreaBase

The left position of the text area (ignored unless [[position]] is set to 'Custom').

 
get left(): number

Returns number 

set left(a: number): void

Parameters

  • a: number

Returns void

overlay

Section titled "overlay"

Determines whether the chart title is laid over the plot area.

 
get overlay(): boolean

Returns boolean 

set overlay(a: boolean): void

Parameters

  • a: boolean

Returns void

owner

Section titled "owner"

Inherited from: ChartTextAreaBase

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

position

Section titled "position"

Inherited from: ChartTextAreaBase

Determines whether the position of the text area is automatic or custom as specified by the [[left]] and [[top]] properties.

 
get position(): ElementPosition

Returns ElementPosition 

set position(a: ElementPosition): void

Parameters

Returns void

readingOrder

Section titled "readingOrder"

Inherited from: ChartTextAreaBase

Determines the reading order

 
get readingOrder(): ReadingOrder

Returns ReadingOrder 

set readingOrder(a: ReadingOrder): void

Parameters

Returns void

rotation

Section titled "rotation"

Inherited from: ChartTextAreaBase

Determines the rotation of the text area, expressed in degrees.

 
get rotation(): number

Returns number 

set rotation(a: number): void

Parameters

  • a: number

Returns void

sheet

Section titled "sheet"

Inherited from: ChartTextAreaBase

The owning sheet (read-only)

 
get sheet(): Sheet

Returns Sheet

text

Section titled "text"

Inherited from: ChartTextAreaBase

Returns or sets a [[FormattedString]] object which defines the text to be displayed by the associated chart element.

 
get text(): FormattedString

Returns FormattedString 

set text(a: FormattedString): void

Parameters

Returns void

textDirection

Section titled "textDirection"

Inherited from: ChartTextAreaBase

Determines the orientation and direction in which text flows.

 
get textDirection(): TextDirection

Returns TextDirection 

set textDirection(a: TextDirection): void

Parameters

Returns void

top

Section titled "top"

Inherited from: ChartTextAreaBase

The top position of the text area (ignored unless [[position]] is set to 'Custom').

 
get top(): number

Returns number 

set top(a: number): void

Parameters

  • a: number

Returns void

verticalAlignment

Section titled "verticalAlignment"

Inherited from: ChartTextAreaBase

Determines the vertical alignment of the text area.

 
get verticalAlignment(): VerticalTitleAlignment

Returns VerticalTitleAlignment 

set verticalAlignment(a: VerticalTitleAlignment): void

Parameters

Returns void

verticalOverflow

Section titled "verticalOverflow"

Inherited from: ChartTextAreaBase

Determines whether text is allowed to continue vertically outside the bounds of the containing element.

 
get verticalOverflow(): TextVerticalOverflow

Returns TextVerticalOverflow 

set verticalOverflow(a: TextVerticalOverflow): void

Parameters

Returns void

workbook

Section titled "workbook"

Inherited from: ChartTextAreaBase

The owning workbook (read-only)

 
get workbook(): Workbook

Returns Workbook

worksheet

Section titled "worksheet"

Inherited from: ChartTextAreaBase

The owning worksheet (read-only)

 
get worksheet(): Worksheet

Returns Worksheet

wrapText

Section titled "wrapText"

Inherited from: ChartTextAreaBase

Determines whether text is wrapped when it would exceed the bounds of the containing element.

 
get wrapText(): boolean

Returns boolean 

set wrapText(a: boolean): void

Parameters

  • a: boolean

Returns void

Methods

Section titled "Methods"

setFormula

Section titled "setFormula"

Inherited from: ChartTextAreaBase

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