Hi All! , I want Creating Chart Multi-series from database as I add one second category and its value in asp
dim FC
set FC = new FusionCharts
Call FC.setChartType("MSColumn3D")
Call FC.setSize("650","450")
Call FC.setSWFPath("../Graficas/FusionCharts/")
dim strParam
strParam="caption=Weekly Sales;subcaption=Comparison;xAxisName=Week;yAxisName=Revenue;numberPrefix=$"
Call FC.setChartParams(strParam)
Dim oRs
Set oRs = Server.CreateObject("ADODB.Recordset")
dim strQuery
strQuery = "SELECT Fecha, Fix, Dof FROM TIPOCAMBIO ORDER BY FECHA DESC"
Set oRs = oConn.Execute(strQuery)
if not oRs.bof then
Call FC.addDataFromDatabase(oRs, "Fix", "Fecha", "" ,"")
end if
oRs.Close
set oRs=Nothing
Call FC.renderChart(false)
How I Can add Dof ?