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

Hierarchy

Hierarchy

Constructors

Properties

$type: Type
$t: Type
nextHashCode: number

Accessors

  • 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: ChartFillBase): 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: boolean): 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: string): 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: boolean): 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: number): 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: ReadingOrder): 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: number): 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: TextDirection): 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

  • 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