Methods

add(area, isVertical) → Number

Adds the SeriesCollection collection to a chart. If set data on contiguous cells, use colon to seperate them.For example, $C$2:$C$5.If set data on non contiguous cells, use comma to seperate them.For example: ($C$2,$D$5).

Parameters

Name Type Optional Description

area

String

 

Specifies values from which to plot the data series

isVertical

boolean

 

Specifies whether to plot the series from a range of cell values by row or by column.

Returns

Number Return the first index of the added ASeries in the NSeries.

add(area, isVertical, checkLabels) → Number

Adds the SeriesCollection collection to a chart. If set data on contiguous cells, use colon to seperate them.For example, $C$2:$C$5.If set data on non contiguous cells, use comma to seperate them.For example, ($C$2,$D$5).

Parameters

Name Type Optional Description

area

String

 

Specifies values from which to plot the data series

isVertical

boolean

 

Specifies whether to plot the series from a range of cell values by row or by column.

checkLabels

boolean

 

Indicates whether the range contains series's name

Returns

Number Return the first index of the added ASeries in the NSeries.

add()

Reserved for internal use.

addR1C1(area, isVertical) → Number

Adds the SeriesCollection collection to a chart. If set data on contiguous cells, use colon to seperate them.For example, R[1]C[1]:R[3]C[2].If set data on contiguous cells, use comma to seperate them.For example,(R[1]C[1],R[3]C[2]).

Parameters

Name Type Optional Description

area

String

 

Specifies values from which to plot the data series

isVertical

boolean

 

Specifies whether to plot the series from a range of cell values by row or by column.

Returns

Number Return the first index of the added ASeries in the NSeries.

changeSeriesOrder(sourceIndex, destIndex)

Directly changes the orders of the two series.

Parameters

Name Type Optional Description

sourceIndex

Number

 

The current index

destIndex

Number

 

The dest index

clear()

Clears the collection

contains()

Reserved for internal use.

get(index) → Series

Gets the Series element at the specified index.

Parameter

Name Type Optional Description

index

Number

 

The zero based index of the element.

Returns

Series The element at the specified index.

get()

Reserved for internal use.

getCategoryData()

Gets or sets the range of category Axis values. It can be a range of cells (such as, "d1:e10"), or a sequence of values (such as,"{2,6,8,10}").

getCount()

getSecondCategoryData()

Gets or sets the range of second category Axis values. It can be a range of cells (such as, "d1:e10"), or a sequence of values (such as,"{2,6,8,10}"). Only effects when some ASerieses plot on the second axis.

getSeriesByOrder(order) → Series

Gets the Series element by order.

Parameter

Name Type Optional Description

order

Number

 

The order of series

Returns

Series The element series

indexOf()

Reserved for internal use.

isColorVaried()

Represents if the color of points is varied.

iterator()

removeAt(index)

Remove at a series at the specific index.

Parameter

Name Type Optional Description

index

Number

 

The index.

setCategoryData()

Gets or sets the range of category Axis values. It can be a range of cells (such as, "d1:e10"), or a sequence of values (such as,"{2,6,8,10}").

setColorVaried()

Represents if the color of points is varied.

setSecondCategoryData()

Gets or sets the range of second category Axis values. It can be a range of cells (such as, "d1:e10"), or a sequence of values (such as,"{2,6,8,10}"). Only effects when some ASerieses plot on the second axis.

setSeriesNames(startIndex, area, isVertical)

Sets the name of all the serieses in the chart. If the start index is larger than the count of the serieses, it will return and do nothing.If set data on contiguous cells, use colon to seperate them.For example, $C$2:$C$5.If set data on contiguous cells, use comma to seperate them.For example, ($C$2,$D$5).

Parameters

Name Type Optional Description

startIndex

Number

 

The index of the first series which you want to set the name.

area

String

 

Specifies the area for the series name.

isVertical

boolean

 

Specifies whether to plot the series from a range of cell values by row or by column.