Represents the tick-mark labels associated with tick marks on a chart [[Axis]].

TickLabels

new TickLabels(a: IChartObject): TickLabels

Returns TickLabels

Specifies the alignment of the tick labels

get alignment(): TickLabelAlignment

Returns TickLabelAlignment

set alignment(a: TickLabelAlignment): void

Parameters

Returns void

Inherited from: ChartObject

Returns the owning chart (read-only)

get chart(): WorksheetChart

Returns WorksheetChart

Returns or sets a [[ChartFillBase]] derived object which defines the fill applied to the background of tick labels.

get fill(): ChartFillBase

Returns ChartFillBase

set fill(a: ChartFillBase): void

Parameters

Returns void

Specifies which font to use. Read-only. Note: this property will return null until the [[TickLabels]] is set on the Axis.TickLabels property.

get font(): IWorkbookFont

Returns IWorkbookFont

Specifies whether an axis is multilevel or not.

get multiLevel(): boolean

Returns boolean

set multiLevel(a: boolean): void

Parameters

  • a: boolean

Returns void

Returns or sets the format to use for numbers.

get numberFormat(): string

Returns string

set numberFormat(a: string): void

Parameters

  • a: string

Returns void

True if the number format is linked to the cells (so that the number format changes in the labels when it changes in the cells).

get numberFormatLinked(): boolean

Returns boolean

set numberFormatLinked(a: boolean): void

Parameters

  • a: boolean

Returns void

Returns or sets a Long value that represents the distance between the levels of labels, and the distance between the first level and the axis line.

get offset(): number

Returns number

set offset(a: number): void

Parameters

  • a: number

Returns void

Inherited from: ChartObject

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

Determines the reading order

get readingOrder(): ReadingOrder

Returns ReadingOrder

set readingOrder(a: ReadingOrder): void

Parameters

Returns void

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

Inherited from: ChartObject

The owning sheet (read-only)

get sheet(): Sheet

Returns Sheet

Determines the orientation and direction in which text flows.

get textDirection(): TextDirection

Returns TextDirection

set textDirection(a: TextDirection): void

Parameters

Returns void

Inherited from: ChartObject

The owning workbook (read-only)

get workbook(): Workbook

Returns Workbook

Inherited from: ChartObject

The owning worksheet (read-only)

get worksheet(): Worksheet

Returns Worksheet