Stacked bar charts

[trojnfn]

I currently use ColdFusion and StackedColumn3D.swf to produce a stacked chart. The top bar shows total qty coming in and the bottom bar shows total qty going out, per month.

Here is part of the code I am using looks something like this :

<dataset seriesname = "Total Qty In">

<dataset seriesname = "Total Qty Out">

<cfloop query="qryName">

<category name="#month#">

<set value="#qyIN#">

<set value="#qtyOut#">

</cfloop>

<cfoutput>#renderChart("http://#cgi.SERVER_NAME#/Fusion/Charts/StackedColumn3D.swf", "", strXML, "chartID", 760, 600, false, false)#</cfoutput>

</cfoutput>

So far, this works, because I only use one query. However, I now need to use two queries, one to get the total qty coming in and the other to get the total qty going out.

Using two queries, how can still produce the stacked bar chart ?

[Guest Madhumita]

Hi,

Thanks for using FusionCharts.

Stacked chart by nature (as per XML sechme) is a MUlti-series chart.

Could you please refer to the Multiseries chart building code provide in our ColdFusion BluePrint Application : http://www.fusioncharts.com/Downloads/Blueprint/FusionCharts_CF.zip to get more insignt into it?