%
/*You need to include the following JS file, if you intend to embed the chart using JavaScript.
Embedding using JavaScripts avoids the "Click to Activate..." issue in Internet Explorer
When you make your own charts, make sure that the path to this JS file is correct. Else, you would get JavaScript errors.
*/
%>
Plotting Combination chart from data contained in Array.
<%
/*In this example, we plot a Combination chart from data contained
in an array. The array will have three columns - first one for Quarter Name
second one for sales figure and third one for quantity.
*/
String[][] arrData = new String[4][3];
//Store Quarter Name
arrData[0][0] = "Quarter 1";
arrData[1][0] = "Quarter 2";
arrData[2][0] = "Quarter 3";
arrData[3][0] = "Quarter 4";
//Store revenue data
arrData[0][1] = "576000";
arrData[1][1] = "448000";
arrData[2][1] = "956000";
arrData[3][1]= "734000";
//Store Quantity
arrData[0][2]= "576";
arrData[1][2] = "448";
arrData[2][2]= "956";
arrData[3][2]= "734";
String strXML="";
/*Now, we need to convert this data into combination XML.
We convert using string concatenation.
strXML - Stores the entire XML
strCategories - Stores XML for the and child elements
strDataRev - Stores XML for current year's sales
strDataQty - Stores XML for previous year's sales*/
//Initialize element
strXML = "";
//Initialize element - necessary to generate a multi-series chart
String strCategories = "";
//Initiate elements
String strDataRev = "";
String strDataQty = "";
//Iterate through the data
for(int i=0;i to strCategories
strCategories += "";
//Add to both the datasets
strDataRev += "";
strDataQty = strDataQty +"";
}
//Close element
strCategories += "";
//Close elements
strDataRev += "";
strDataQty += "";
//Assemble the entire XML now
strXML += strCategories + strDataRev + strDataQty + "";
//Create the chart - MS Column 3D Line Combination Chart with data contained in strXML
%>
Unable to see the chart
above?