Get Started
Usage API
More information

AddSeria

AddSeria(sNameRange, sValuesRange, [sXValuesRange])

Adds a new series to the current chart.

Parameters:

Name Type Default Description
sNameRange string

The series name. Can be a range of cells or usual text. For example:

  • "'sheet 1'!$A$2:$A$5" - must be a single cell, row or column,
  • "A1:A5" - must be a single cell, row or column,
  • "Example series".
sValuesRange string

A range of cells from the sheet with series values. For example:

  • "'sheet 1'!$A$2:$A$5" - must be a single cell, row or column,
  • "A1:A5" - must be a single cell, row or column.
sXValuesRange string null

A range of cells from the sheet with series x-axis values. It is used with the scatter charts only. For example:

  • "'sheet 1'!$A$2:$A$5" - must be a single cell, row or column,
  • "A1:A5" - must be a single cell, row or column.

Returns:

This method doesn't return any data.