Interface: IDataLabels

Sheets.Charts.IDataLabels

Table of contents

Properties

• backColor
• backColorTransparency
• borderColor
• borderColorTransparency
• borderWidth
• color
• dataLabelsRange
• format
• numberFormatLinked
• position
• separator
• showCategoryName
• showDataLabelsRange
• showPercentage
• showSeriesName
• showValue
• transparency

Properties

backColor

• Optional backColor: string | IPatternFillBackColor

The background color of the series data labels.

backColorTransparency

• Optional backColorTransparency: number

The background color transparency of the series data labels.

borderColor

• Optional borderColor: string

The border color of the series data labels.

borderColorTransparency

• Optional borderColorTransparency: number

The border color transparency of the series data labels.

borderWidth

• Optional borderWidth: number

The border width of the series data labels.

color

• Optional color: string

The color of the chart data labels.

dataLabelsRange

• Optional dataLabelsRange: string

The data labels range formula;

format

• Optional format: string

The format of the chart data labels.

numberFormatLinked

• Optional numberFormatLinked: boolean

Whether to apply the format of the linked data source.

position

• Optional position: DataLabelPosition

The position of the chart data labels.

separator

• Optional separator: string

the separator of the series data labels.

showCategoryName

• Optional showCategoryName: boolean

Whether to show category name in data labels.

showDataLabelsRange

• Optional showDataLabelsRange: boolean

Whether to show the reference cells text in data labels.

showPercentage

• Optional showPercentage: boolean

Whether to show the percent value in data labels.

showSeriesName

• Optional showSeriesName: boolean

Whether to show series name in data labels.

showValue

• Optional showValue: boolean

Whether to show value in data labels.

transparency

• Optional transparency: number

The transparency of the chart data labels color.