Set categories names from data stored in a single-dimension array.
object.SetCategoriesFromArray( categories )
The following JScript code shows how to store the series and categories of the table below using the SetCategoriesFromArray method. This table has two series named "Year 2000" and "Year 2001". The categories are "North America", "South America", "Europe", "Middle East" and "Asia".
|
||||||||||||||||||
![]() |
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.SetSeriesCaption(0, "Year 2000"); chart.SetSeriesValuesFromArray(0, myArray); // Do the same way for the second series "Year 2001"
SetCategoriesFromString Method | GetCategory Method
Applies To: Chart Object