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 with the method AddSeries has no caption.

The data stored in the array must be string values.


JScript Sample Code

The following JScript 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 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

var myArray= new Array(5);
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 myArray variable
chart.AddSeries();
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.SetSeriesValuesFromArray(1, myArray);

//Specify the 2 series captions
var myCaptions= new Array(2)
myCaptions[0]= "Year 2000";
myCaptions[1]= "Year 2001";

//Set the series captions with the strings stored in the myCaptions variable
chart.SetSeriesCaptionsFromArray( myCaptions );

See Also

SetSeriesCaptionsFromString Method | GetSeriesCaption Method | GetSeriesValue Method | GetSeriesCount Method

Applies To: Chart Object