Interface: ISeries

Sheets.Charts.ISeries

Table of contents

Properties

• axisGroup
• backColor
• backColorTransparency
• border
• bubbleSizes
• chartType
• dataLabels
• dataPoints
• doughnutHoleSize
• errorBars
• gapWidth
• invertColor
• invertIfNegative
• name
• overlap
• plotVisibleOnly
• showConnectorLines
• smooth
• startAngle
• subtotals
• symbol
• trendlines
• xValues
• yValues

Properties

axisGroup

• Optional axisGroup: AxisGroup

The axis group of the series.

---

backColor

• Optional backColor: string | IPatternFillBackColor

The background color of the series.

---

backColorTransparency

• Optional backColorTransparency: number

The transparency of the series background color.

---

border

• Optional border: ISeriesItemBorder

The border of the series.

---

bubbleSizes

• Optional bubbleSizes: string

The bubble sizes formula of the series. This is used for bubble chart.

---

chartType

• Optional chartType: ChartType

The chart type of the series.

---

dataLabels

• Optional dataLabels: IDataLabels

The data labels of the series.

---

dataPoints

• Optional dataPoints: IDataPoints

The data points of the series.

---

doughnutHoleSize

• Optional doughnutHoleSize: number

The hole size of the doughnut chart. This is used for doughnut chart, The maximum value is 0.9, the minimum value is 0.

---

errorBars

• Optional errorBars: ErrorBarItems

The error bars of the series.

---

gapWidth

• Optional gapWidth: number

The gap width of the bar and column chart group. The maximum value is 5, the minimum value is 0.

---

invertColor

• Optional invertColor: string

The series point value is negative color when seriesItem type is column or bar chart and invertIfNegative is true.

---

invertIfNegative

• Optional invertIfNegative: boolean

The series point value is negative color when seriesItem type is column or bar chart and invertIfNegative is true.

---

name

• Optional name: string

The name formula of the series.

---

overlap

• Optional overlap: number

The overlap of the bar and column chart group. The maximum value is 1, the minimum value is -1.

---

plotVisibleOnly

• Optional plotVisibleOnly: boolean

Whether to show data in hidden rows and columns.

---

showConnectorLines

• Optional showConnectorLines: boolean

Whether the series show connector lines. This is used for waterfall chart, The default value is false.

---

smooth

• Optional smooth: boolean

Whether to display smooth lines. This is used for line chart and scatter chart.

---

startAngle

• Optional startAngle: number

The first slice angle of the chart whose chart type is pie. The default value is 0, which represents the 12 o'clock position.

---

subtotals

• Optional subtotals: number[]

The waterfall chart set as total points index array(0 base). This is used for waterfall chart, The default value is empty array.

---

symbol

• Optional symbol: ISymbol

The symbol of the series.

---

trendlines

• Optional trendlines: TrendlineItem[]

The trendlines of the series.

---

xValues

• Optional xValues: string

The x values formula of the series.

---

yValues

• Optional yValues: string

The y values formula of the series.