Set series values from data stored in a single-dimension array.

object.SetSeriesValuesFromArray 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 values as elements.

Remarks

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 SetSeriesValuesFromArray method raises an out of bounds error.

Use the AddSeries Method to create a new empty series.

VBScript Sample Code

The following VBScript code shows how to store the series and categories of the table below using the SetSeriesValuesFromArray method. This table has two series named "Year 2000" and "Year 2001". The categories are "North America", "South America", "Europe", "Middle East" and "Asia".

  North America South America Europe Middle East Asia
Year 2000 12 7.5 11.3 9.2 5.3
Year 2001 14 9.9 13.1 11.5 4.9

Dim myArray(4)
myArray(0)= "North America"
myArray(1)= "South America"
myArray(2)= "Europe"
myArray(3)= "Middle East"
myArray(4)= "Asia"

'Fill the chart with the categories stored in the myArray variable
chart.SetCategoriesFromArray myArray

'Add the first series "Year 2000"
myArray(0)= 12
myArray(1)= 7.5
myArray(2)= 11.3
myArray(3)= 9.2
myArray(4)= 5.3

'Fill the first series with the data stored in the myString variable
chart.AddSeries
chart.SetSeriesCaption 0, "Year 2000"
chart.SetSeriesValuesFromArray 0, myArray

'Add the second series "Year 2001"
myArray(0)= 14
myArray(1)= 9.9
myArray(2)= 13.1
myArray(3)= 11.5
myArray(4)= 4.9

'Fill the second series with the data stored in the myArray variable
chart.AddSeries
chart.SetSeriesCaption 1, "Year 2001"
chart.SetSeriesValuesFromArray 1, myArray

See Also

AddSeries Method | GetSeriesCount Method | SetSeriesValuesFromString Method | SetSeriesCaption Method | GetSeriesValue Method

Applies To: Chart Object