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.