HOLA

[Jorge Alberto Garc]

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 ?

 

 

[Guest Basundhara Ghosal]

Hi,

Welcome to FusionCharts forum.

Please refer to the links below for the detailed information on the same :-

Ref.- http://www.fusioncharts.com/docs/?/ASP_DB.html

http://www.fusioncharts.com/docs?/ASP_BasicExample.html

Also, please refer to the 'DBExample' folder of the FusionCharts pack for the same.

Ref.- FusionCharts_Pack -> Code -> ASP -> DBExample

I hope this helps.