Set series Y values from data stored in a single-dimension array (for XY-Scatter and XY-Curves).

object.SetSeriesYValuesFromArray index, values 

Arguments

object
Required. A Chart object.
index
Required. An integer value that specifies the zero-based index of the series in the chart object.
values
Required. A single-dimension array containing the series Y values as elements.

Remarks

Note: This method is available when manipulating XY data series required for displaying XY-Curves and XY-Scatter. Note that the Chart type (ie: bar, column, line, etc.) is defined in the Swiff Chart style file (.scs) which must be loaded via the LoadStyle method.

The data stored in the array must be numerical values.

If the index argument refers to a series that does not exist in the chart object, the series is created.

VBScript Sample Code

The following VBScript code shows how to store the XY values of the table below using the SetSeriesYValuesFromArray method. This table has two series named "Year 2006" and "Year 2007". Each of these two series contains independant X values and Y values.

Year 2006 Year 2007
X
Y
X
Y
1
12
1.5
14
2
7.5
1.8
9.9
3
11.3
3.7
13.1
4
9.2
3.9
11.5
5
5.3
5.8
4.9
  

Dim array_x(4)
Dim array_y(4)

array_x(0)= 1
array_x(1)= 2
array_x(2)= 3
array_x(3)= 4
array_x(4)= 5

array_y(0)= 12
array_y(1)= 7.5
array_y(2)= 11.3
array_y(3)= 9.2
array_y(4)= 5.3

'Add the first series "Year 2006"
chart.SetSeriesCaption 0, "Year 2006"

'Fill the first series with XY values stored in the array variables
chart.SetSeriesXValuesFromArray 0, array_x
chart.SetSeriesYValuesFromArray 0, array_y

array_x(0)= 1.5
array_x(1)= 1.8
array_x(2)= 3.7
array_x(3)= 3.9
array_x(4)= 5.8

array_y(0)= 14
array_y(1)= 9.9
array_y(2)= 13.1
array_y(3)= 11.5
array_y(4)= 4.9

'Add the first series "Year 2007"
chart.SetSeriesCaption 1, "Year 2007"

'Fill the second series with XY values stored in the array variables
chart.SetSeriesXValuesFromArray 1, array_x
chart.SetSeriesYValuesFromArray 1, array_y

See Also

GetSeriesCount Method | SetSeriesYValuesFromString Method | SetSeriesCaption Method | GetSeriesYValue Method

Applies To: Chart Object