Multiple Series Dynamic Stacked Charts

[anirbansarkar]

Hi,

 

I want to create a multi series column stacked chart where the bank deposit dates will appear in the X axis and there will be a stacked column against each of the deposit dates. The stacks will consist of amount deposited in different banks for that particular date. Kindly note that the number of stacks in each column will not be fixed as it will depend on the number of banks where the amount has been deposited for the day.

 

To be more specific, the number of stacks for one date can be three whereas for another date it can be five and so on.

 

The entire stuff has to be database driven.

 

Is such a kind of chart possible using fusion charts? I have gone through the chart gallery for stacked charts and in all the examples given, I find that the number of stacks across all the columns are fixed.

 

If this is possible, kindly help.

 

Thanks and regards,

Anirban Sarkar

[Guest Sumedh]

Hi Anirban,

 

You can plot Multi-series Stacked Column chart according to your requirement.

 

You would need to pass empty or null value for that particular plot. So, you need to retrieve data from database accordingly to generate such chart XML.

 

Hope this helps!

[FusionCharts Support]

For example:

 

If you use the following data:

 

<chart caption='Bank Deposits' xAxisName='Date' yAxisName='Amount' showValues='0' numberPrefix='$'>

  <categories>
     <category label='Jan' />
     <category label='Feb' />
     <category label='Mar' />
     <category label='Apr' />
  </categories>

  <dataset seriesName='Bank A'>
     <set />
     <set value='29800'/>
     <set value='25800' />
     <set value='26800' />
  </dataset>
  <dataset seriesName='Bank B'>
     <set  />
     <set  />
     <set value='31800' />
     <set value='36700' />
  </dataset>
  <dataset seriesName='Bank C'>
     <set value='29700' />
     <set value='31900' />
     <set  />
     <set value='4800' />
  </dataset>

  <dataset seriesName='Bank D'>
     <set value='10000'/>
     <set value='11500'/>
     <set />
     <set value='5000'/>
  </dataset>
  <dataset seriesName='Bank E'>
     <set  />
     <set value='9800' />
     <set value='11800' />
     <set  />
  </dataset>
  <dataset seriesName='Bank F'>
     <set value='21700' />
     <set  />
     <set value='22900' />
     <set />
  </dataset>


</chart> 

 

You will get a chart similar to:

 

[pc06matt]

Hi Team,

 

I know this is an old discussion. But I have same requirement in Multi-series LINE as well as AREA chart. And I tried this above suggestion, seems like it's not working.

 

Are we not supporting "<set />" now in latest fusioncharts??
 

Could you please also let me know if there is not some other way to miss a category in a data-set for multi-series charts, specifically?
Thanks in advance!