anirbansarkar

Multiple Series Dynamic Stacked Charts

Recommended Posts

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

Share this post


Link to post
Share on other sites
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!

Share this post


Link to post
Share on other sites

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:

 

post-179-0-13660000-1349948114_thumb.jpg

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now