The 'values' property

Numeric vector or matrix

Valid for: Series

The values property provides a quick way of specifying the X and Y values of a Series in one operation. You can assign to it in the following ways (they are tested for in this order):

(a) 2 by N numeric matrix:

In this case the first row is assumed to contain the X values, and the second row the Y values.

(b) N by 2 numeric matrix:

In this case the first column is assumed to contain the X values, and the second row the Y values. (Note: for a 2 by 2 matrix, case (a) applies).

(c) Numeric scalar, vector, 1 by N matrix, or N by 1 matrix:,

In this case the data provided is assumed to represent the Y values of the series, and the X values are implicitly set to 0, 1, 2....N-1

If you read back this property, the data is always returned in format (a), i.e. as a 2 by N matrix of X values, Y Values

Note that you can also set the X and Y values separately using the xvalues and yvalues properties.