Specifies all the series captions from strings stored in a single-dimension array.

object.SetSeriesCaptionsFromArray captions

Arguments

object: Required. A Chart object.
captions: Required. A single-dimension array containing the series captions as elements.

Remarks

By default, a new data series added to a chart has no caption.

If some series do not exist, they are created only if the corresponding caption is not empty.

The data stored in the array must be string values.

VBScript Sample Code

The following VBScript code shows how to specify the series captions corresponding to the table below using the SetSeriesCaptionsFromArray method. This table has two series with captions "Year 2006" and "Year 2007". The categories are "North America", "South America", "Europe", "Middle East" and "Asia".

	North America	South America	Europe	Middle East	Asia
Year 2006	12	7.5	11.3	9.2	5.3
Year 2007	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 2006"
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 myArray variable
chart.SetSeriesValuesFromArray 0, myArray

'Add the second series "Year 2007"
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.SetSeriesValuesFromArray 1, myArray

'Specify the 2 series captions
Dim myCaptions(1)
myCaptions(0)= "Year 2006"
myCaptions(1)= "Year 2007"

'Set the series captions with the strings stored in the myCaptions variable
chart.SetSeriesCaptionsFromArray myCaptions

Arguments

Remarks

VBScript Sample Code

See Also