Hi,
I have set category labels as below. I have two data sets for the multi-series bar chart.
The first dataset has all data points, in the right order. The second dataset ('BENCHMARK FUEL MIX') does not have a value for "NUCLEAR" and the data is generated in a different order in sql, so comes out in a different order when constructing the xml.
The second dataset : set name='HYDRO' does not pass the value to the 'Hydro' category. Because it is the first in the dataset list, its value is passed to the first category in the category list, Nuclear.
How do I get fusioncharts to recognise that I am passing a value for hydro, that needs to show in in the hydro category?
<chart caption='YOUR PORFOLIO AND BENCHMARK'
xAxisName='FUEL' yAxisName='Persentage' showValues='0' numberSuffix='%'
chartOrder='line,area,column' >
<categories>
<category label='NUCLEAR'/>
<category label='COAL'/>
<category label='HYDRO'/>
</categories>
<dataset seriesName='USER FUEL MIX'>
<set name='NUCLEAR' value='0.51314510033995527343252'/>
<set name='COAL' value='0.16717460403856217640270'/>
<set name='HYDRO' value='0.15279657767844008918241'/>
</dataset>
<dataset seriesName='BENCHMARK FUEL MIX'>
<set name='HYDRO' value='0.00001690385748955934983'/>
<set name='COAL' value='0.98261366271075040777074'/>
</dataset>
</chart>
Many thanks,
Mark