Do not show zero values in chart

[Adis Corovic]

Hi all,

 

 

 

Question:

 

I do not want to show any zero values in my MSColumn3D. I generate the XML file so in my dataset I do have values that contain <0>. See the following XMl file:

 

 

 

See attached file...

 

 

 

So the last dataset contains a zero value and the chart shows a tiny stripe with the valu 0. I want to show every values except the zero values? Please help.. thanks in advance.

Data.xml

Edited June 18, 2009 by Guest

[saptarshi]

Hello Adis,

 

 

 

Welcome to the forum.

 

 

 

I am afraid FusionCharts will show all values that is fed through the XML.

 

 

 

The only way to achieve what you are asking for is by changing the XML.

 

 

 

This has to be done by you programmatically so that in the XML created through that program all zero values are excluded.

 

 

 

Hope this helps.

[Adis Corovic]

Hi Saptarshi,

In the last version that I have used (FusionChartFree) this problem did not occured?

I will try to reproduce this and make a vido so that you can see this.

[Guest Rajroop]

Hello Adis,

 

 

 

Welcome to the forum. [smile]

 

 

 

I am afraid FusionCharts will show all values that is fed through the XML.

 

 

 

The only way to achieve what you are asking for is by changing the XML.

 

 

 

This has to be done by you programmatically so that in the XML created through that program all zero values are excluded.

 

 

 

Hope this helps. [smile]

 

 

 

Regards,

 

Saptarshi Chakraborty

 

Ask me do! [Discuss]

 

 

 

As, Saptarshi has mentioned, FusionCharts will show all values that is fed through the XML.

 

 

 

However, if you require not to show a certain value of a particular dataset, as you've mentioned the zero value of the last dataset of your chart, then could you please try adding showValue='0' in that particular set element?

 

 

 

I hope this helps.

[Adis Corovic]

Thanks for your reply. I will use a workaround:

I will edit the sql query so that the value is NULL instead of 0.

Thanks for your help!

[Guest Rajroop]

Glad that you've worked it out.

 

 

 

Happy FusionCharting.