Set series values from data stored in a single-dimension array.
object.SetSeriesValuesFromArray index, values
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.
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".
|
||||||||||||||||||
![]() |
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
AddSeries Method | GetSeriesCount Method | SetSeriesValuesFromString Method | SetSeriesCaption Method | GetSeriesValue Method
Applies To: Chart Object