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

Hierarchy

Hierarchy (view full)

Constructors

Properties

$type: Type
$t: Type
nextHashCode: number

Accessors

  • get alignment(): TickLabelAlignment
  • Specifies the alignment of the tick labels

    Returns TickLabelAlignment

  • set alignment(a): void
  • Parameters

    Returns void

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

    See

    [[owner]]

    Returns WorksheetChart

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

    This property is not applicable for BoxAndWhisker, Histogram, Pareto, Sunburst, Treemap, or Waterfall charts.

    Returns ChartFillBase

  • set fill(a): void
  • Parameters

    Returns void

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

    Returns IWorkbookFont

  • get multiLevel(): boolean
  • Specifies whether an axis is multilevel or not.

    Returns boolean

  • set multiLevel(a): void
  • Parameters

    • a: boolean

    Returns void

  • get numberFormat(): string
  • Returns or sets the format to use for numbers.

    Note that in some cases it may be necessary to set [[numberFormatLinked]] to false in order to see the format applied. If the tick labels are not displaying the format you specified, try setting NumberFormatLinked to false.

    See

    [[numberFormatLinked]]

    Returns string

  • set numberFormat(a): void
  • Parameters

    • a: string

    Returns void

  • get numberFormatLinked(): boolean
  • 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).

    Note that in some cases it may be necessary to set this property to false in order to see the [[numberFormat]] applied. If the tick labels are not displaying the format you specified, try setting this property to false.

    See

    [[numberFormat]]

    Returns boolean

  • set numberFormatLinked(a): void
  • Parameters

    • a: boolean

    Returns void

  • get offset(): number
  • 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.

    Returns number

  • set offset(a): void
  • Parameters

    • a: number

    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 readingOrder(): ReadingOrder
  • Determines the reading order

    Returns ReadingOrder

  • set readingOrder(a): void
  • Parameters

    Returns void

  • get rotation(): number
  • Determines the rotation of the text area, expressed in degrees.

    The Rotation property is only applicable when [[textDirection]] is set to Horizontal.

    See

    [[textDirection]]

    Returns number

  • set rotation(a): void
  • Parameters

    • a: number

    Returns void

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

    Returns Sheet

  • get textDirection(): TextDirection
  • Determines the orientation and direction in which text flows.

    Note that the [[rotation]] property is only applicable when this property is set to Horizontal.

    See

    [[rotation]]

    Returns TextDirection

  • set textDirection(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