Defines the properties for all data labels displayed for this [[Series]].

Constructors

Section titled "Constructors"

SeriesDataLabels

new SeriesDataLabels(a: Series): SeriesDataLabels

Returns SeriesDataLabels

Properties

Section titled "Properties"

$t

Section titled "$t" 
$t: Type

border

Section titled "border"

Inherited from: DataLabel 

border: ChartBorder

fill

Section titled "fill"

Inherited from: DataLabel 

fill: ChartFillBase

height

Section titled "height"

Inherited from: DataLabel 

height: number

horizontalOverflow

Section titled "horizontalOverflow"

Inherited from: DataLabel 

horizontalOverflow: TextHorizontalOverflow

isDeleted

Section titled "isDeleted"

Inherited from: DataLabel 

isDeleted: boolean

labelPosition

Section titled "labelPosition"

Inherited from: DataLabel 

labelPosition: DataLabelPosition

left

Section titled "left"

Inherited from: DataLabel 

left: number

numberFormat

Section titled "numberFormat"

Inherited from: DataLabel 

numberFormat: string

numberFormatLinked

Section titled "numberFormatLinked"

Inherited from: DataLabel 

numberFormatLinked: boolean

parentLabelLayout

Section titled "parentLabelLayout" 
parentLabelLayout: ParentLabelLayout

position

Section titled "position"

Inherited from: DataLabel 

position: ElementPosition

readingOrder

Section titled "readingOrder"

Inherited from: DataLabel 

readingOrder: ReadingOrder

rotation

Section titled "rotation"

Inherited from: DataLabel 

rotation: number

separator

Section titled "separator"

Inherited from: DataLabel 

separator: string

showBubbleSize

Section titled "showBubbleSize"

Inherited from: DataLabel 

showBubbleSize: boolean

showCategoryName

Section titled "showCategoryName"

Inherited from: DataLabel 

showCategoryName: boolean

showLeaderLines

Section titled "showLeaderLines" 
showLeaderLines: boolean

showLegendKey

Section titled "showLegendKey"

Inherited from: DataLabel 

showLegendKey: boolean

showPercentage

Section titled "showPercentage"

Inherited from: DataLabel 

showPercentage: boolean

showRange

Section titled "showRange"

Inherited from: DataLabel 

showRange: boolean

showSeriesName

Section titled "showSeriesName"

Inherited from: DataLabel 

showSeriesName: boolean

showValue

Section titled "showValue"

Inherited from: DataLabel 

showValue: boolean

text

Section titled "text"

Inherited from: DataLabel 

text: FormattedString

textDirection

Section titled "textDirection"

Inherited from: DataLabel 

textDirection: TextDirection

top

Section titled "top"

Inherited from: DataLabel 

top: number

verticalAlignment

Section titled "verticalAlignment"

Inherited from: DataLabel 

verticalAlignment: VerticalTitleAlignment

verticalOverflow

Section titled "verticalOverflow"

Inherited from: DataLabel 

verticalOverflow: TextVerticalOverflow

width

Section titled "width"

Inherited from: DataLabel 

width: number

wrapText

Section titled "wrapText"

Inherited from: DataLabel 

wrapText: boolean

Accessors

Section titled "Accessors"

chart

Section titled "chart"

Inherited from: DataLabel

Returns the owning chart (read-only)

get chart(): WorksheetChart

Returns WorksheetChart

dataLabelsRange

Section titled "dataLabelsRange"

Returns a [[Formula]] which defines the cell range from which part or all of the label text is obtained.

get dataLabelsRange(): Formula

Returns Formula

defaultFont

Section titled "defaultFont"

Inherited from: DataLabel

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: DataLabel

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: DataLabel

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: DataLabel

The owning sheet (read-only)

get sheet(): Sheet

Returns Sheet

workbook

Section titled "workbook"

Inherited from: DataLabel

The owning workbook (read-only)

get workbook(): Workbook

Returns Workbook

worksheet

Section titled "worksheet"

Inherited from: DataLabel

The owning worksheet (read-only)

get worksheet(): Worksheet

Returns Worksheet

Methods

Section titled "Methods"

setDataLabelsRange

Section titled "setDataLabelsRange"

Assigns a [[Formula]] to the [[dataLabelsRange]]

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

Parameters

  • formula: string

    The string representation of the formula used to obtain the data label 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

setFormula

Section titled "setFormula"

Inherited from: DataLabel

Not supported.

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

Parameters

Returns void

staticInit

Section titled "staticInit" 
staticInit(): void

Returns void