XL_SERIES()

 

Version Ref: 6.1 (USP 6.0.02)

 

Syntax:

 

 e = XL_SERIES(chartnum, sheet, namerow, namecol, cfirstrow, cfirstcol, clastrow,
              clastcol, vfirstrow, vfirstcol, vlastrow, vlastcol)
	Add a series to a chart or chartsheet.

	Parameters -
		chartnum  : Handle to a chart or chartsheet to add series.
		sheet     : Handle to sheet to get values from. Use blank, "0", or "-1"
		            to use the default sheet.
		namerow   : Series name row (0 indexed).
		namecol   : Series name column (0 indexed).
		cfirstrow : Categories first row (0 indexed).
		cfirstcol : Categories first column (0 indexed).
		clastrow  : Categories last row (0 indexed).
		clastcol  : Categories last column (0 indexed).
		vfirstrow : Values first row (0 indexed).
		vfirstcol : Values first column (0 indexed).
		vlastrow  : Values last row (0 indexed).
		vlastcol  : Values last column (0 indexed).

	Returns "1" on success and "-1" on error. XL_ERROR() can be called to return
	the last error.