Sign in to follow this  
Zahoor Butt

Stacked Column Chart Not Showing Zero Or Negative Values

Recommended Posts

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 by Zahoor Butt

Share this post


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

post-23884-0-51421700-1326429664_thumb.png

Edited by Bindhu

Share this post


Link to post
Share on other sites

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 :)

Share this post


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

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
Sign in to follow this