Stacked Column Chart Not Showing Zero Or Negative Values

[Zahoor Butt]

hi

 

I'm new to Fusion Charts and using StackedColumn3DLine.swf chart but it's not showing negative values except the first negative value. Also it does not show zero values.

 

I've attached sample.xml for your review.

 

 

Please help!

 

 

 

Zahoor

 

 

 

<

 

 

chart palette='3' caption='Alberta Division' numberprefix='$' labelDisplay='ROTATE' xaxisName='Income Statement' useRoundEdges='1' showValues='0' legendBorderAlpha='0'>

 

<

 

 

categories>

 

<

 

 

category label='A' />

 

<

 

 

category label='B' />

 

<

 

 

category label='C' />

 

<

 

 

category label='D' />

 

<

 

 

category label='E' />

 

<

 

 

category label='F' />

 

<

 

 

category label='G' />

 

<

 

 

category label='H' />

 

<

 

 

category label='I' />

 

<

 

 

category label='J' />

 

<

 

 

category label='K' />

 

<

 

 

category label='L' />

 

<

 

 

category label='M' />

 

<

 

 

category label='N' />

 

<

 

 

category label='O' />

 

<

 

 

category label='P' />

 

<

 

 

category label='Q' />

 

<

 

 

category label='R' />

 

<

 

 

category label='S' />

 

<

 

 

category label='T' />

 

<

 

 

category label='U' />

 

<

 

 

category label='V' />

 

<

 

 

category label='W' />

 

<

 

 

category label='X' />

 

<

 

 

category label='Y' />

 

<

 

 

category label='Z' />

 

<

 

 

category label='AA' />

 

<

 

 

category label='AB' />

 

<

 

 

category label='AC' />

 

<

 

 

category label='AD' />

 

<

 

 

category label='AE' />

 

<

 

 

category label='AF' />

 

</

 

 

categories>

 

<

 

 

dataset seriesname='T' color='FD0505'>

 

<

 

 

set value='-185750.11' />

 

<

 

 

set value='0.00' />

 

<

 

 

set value='0.00' />

 

<

 

 

set value='0.00' />

 

<

 

 

set value='0.00' />

 

<

 

 

set value='0.00' />

 

<

 

 

set value='0.00' />

 

<

 

 

set value='0.00' />

 

<

 

 

set value='62.33' />

 

<

 

 

set value='0.00' />

 

<

 

 

set value='0.00' />

 

<

 

 

set value='0.00' />

 

<

 

 

set value='0.00' />

 

<

 

 

set value='0.00' />

 

<

 

 

set value='0.00' />

 

<

 

 

set value='0.00' />

 

<

 

 

set value='0.00' />

 

<

 

 

set value='0.00' />

 

<

 

 

set value='0.00' />

 

<

 

 

set value='0.00' />

 

<

 

 

set value='0' />

 

<

 

 

set value='0.00' />

 

<

 

 

set value='0' />

 

<

 

 

set value='0.00' />

 

<

 

 

set value='-13501.07' />

 

<

 

 

set value='0.00' />

 

<

 

 

set value='0.00' />

 

<

 

 

set value='0.00' />

 

<

 

 

set value='0.00' />

 

<

 

 

set value='0.00' />

 

<

 

 

set value='-7645.00' />

 

<

 

 

set value='0.00' />

 

</

 

 

dataset>

 

<

 

 

dataset seriesname='R' color='BCE8E2'>

 

<

 

 

set value='7045519.30' />

 

<

 

 

set value='234748.41' />

 

<

 

 

set value='368518.09' />

 

<

 

 

set value='80406.19' />

 

<

 

 

set value='231010.62' />

 

<

 

 

set value='372131.79' />

 

<

 

 

set value='111694.12' />

 

<

 

 

set value='4271715.43' />

 

<

 

 

set value='561237.44' />

 

<

 

 

set value='847029.98' />

 

<

 

 

set value='699822.11' />

 

<

 

 

set value='1071065.39' />

 

<

 

 

set value='304556.69' />

 

<

 

 

set value='1537752.09' />

 

<

 

 

set value='687585.05' />

 

<

 

 

set value='605787.85' />

 

<

 

 

set value='723783.84' />

 

<

 

 

set value='509273.74' />

 

<

 

 

set value='1679116.56' />

 

<

 

 

set value='7005294.48' />

 

<

 

 

set value='1038430.24' />

 

<

 

 

set value='1071065.39' />

 

<

 

 

set value='1038430.24' />

 

<

 

 

set value='1092144.94' />

 

<

 

 

set value='4467686.72' />

 

<

 

 

set value='3455634.14' />

 

<

 

 

set value='1569633.21' />

 

<

 

 

set value='7005294.48' />

 

<

 

 

set value='7005294.48' />

 

<

 

 

set value='3486561.26' />

 

<

 

 

set value='1193116.96' />

 

<

 

 

set value='7005294.48' />

 

</

 

 

dataset>

 

<

 

 

dataset seriesname='E' color='E6E032'>

 

<

 

 

set value='6489291.51' />

 

<

 

 

set value='264320.98' />

 

<

 

 

set value='307295.95' />

 

<

 

 

set value='81038.76' />

 

<

 

 

set value='566014.67' />

 

<

 

 

set value='381992.19' />

 

<

 

 

set value='117208.86' />

 

<

 

 

set value='3491382.79' />

 

<

 

 

set value='505907.87' />

 

<

 

 

set value='690134.27' />

 

<

 

 

set value='652664.23' />

 

<

 

 

set value='1008650.39' />

 

<

 

 

set value='285789.80' />

 

<

 

 

set value='1617229.39' />

 

<

 

 

set value='506280.02' />

 

<

 

 

set value='544834.96' />

 

<

 

 

set value='607956.57' />

 

<

 

 

set value='321642.89' />

 

<

 

 

set value='1678636.36' />

 

<

 

 

set value='6375114.77' />

 

<

 

 

set value='893018.12' />

 

<

 

 

set value='1008650.39' />

 

<

 

 

set value='893018.12' />

 

<

 

 

set value='1057035.02' />

 

<

 

 

set value='3770774.79' />

 

<

 

 

set value='3392736.43' />

 

<

 

 

set value='1580340.78' />

 

<

 

 

set value='6375114.77' />

 

<

 

 

set value='6375114.77' />

 

<

 

 

set value='3798839.38' />

 

<

 

 

set value='765190.22' />

 

<

 

 

set value='6375114.77' />

 

</

 

 

dataset>

 

</

 

 

chart>

 

Edited January 12, 2012 by Zahoor Butt

[Guest Bindhu]

Hi Zahoor,

 

Welcome to the FusionCharts Forum

 

Thank you for the post.

 

With regards to your query,

 

As I can see in the XML data that you have posted, the difference between the negative values is very huge.

 

Hence, it appears as though the negative values are not displayed.

 

However, when you use the legend and hide the other series and check, you will be able to see both the negative values and the zero values.

 

To resolve this issue, please try reducing the difference between the negative data values.

 

Since, the yAxisMinValue and yAxisMaxValue is automatically calculated by FusionCharts, it is not recommended to use data values with huge differences.

 

Please find attached screenshot of the chart rendered when the difference between the negative data values is reduced.

 

For more details on 'Stacked Column 3D Chart Specification Sheet', please refer to the link below,

http://docs.fusionch...SS/StCol3D.html

 

Hope this helps !

 

Happy FusionCharting

Edited January 13, 2012 by Bindhu

[Zahoor Butt]

Hi Bindhu',

 

Thank you for your reply. My values are coming from a Database and I have no control over them.

 

Also I'm not sure what do you mean by reducing the difference between negative values?

 

Please help!

 

Regards,

 

Zahoor

 

 

 

 

 

Hi Zahoor,

 

Welcome to the FusionCharts Forum

 

Thank you for the post.

 

With regards to your query,

 

As I can see in the XML data that you have posted, the difference between the negative values is very huge.

 

Hence, it appears as though the negative values are not displayed.

 

However, when you use the legend and hide the other series and check, you will be able to see both the negative values and the zero values.

 

To resolve this issue, please try reducing the difference between the negative data values.

 

Since, the yAxisMinValue and yAxisMaxValue is automatically calculated by FusionCharts, it is not recommended to use data values with huge differences.

 

Please find attached screenshot of the chart rendered when the difference between the negative data values is reduced.

 

For more details on 'Stacked Column 3D Chart Specification Sheet', please refer to the link below,

http://docs.fusionch...SS/StCol3D.html

 

Hope this helps !

 

Happy FusionCharting

[Guest Bindhu]

Hi Zahoor,

 

What I meant was, it is not recommended to use data values with huge difference.

 

That is, if you try to plot 1 and 100000 values on the same chart, then data plot with value 1 will not be visible.

 

In such cases, please try and use our logarithmic charts.

 

For more details on 'Logarithmic Charts', please refer to the link below,

http://docs.fusionch...g/Overview.html

 

Hope this helps!

Edited August 25, 2012 by Bindhu