[]
        
(Showing Draft Content)

GC.Spread.Sheets.Charts.ISeries

Interface: ISeries

Sheets.Charts.ISeries

Table of contents

Properties

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.