0% and No Value in charts

[pulkit476]

i have a table which has values coming out of formulae
e.g.
A - 25.00%
B - 0.00%
D - #N/A
E - No Value



[TABLE="width: 500"]
<tbody>[TR]
[TD]serier[/TD]
[TD]formula[/TD]
[TD]calculated_value[/TD]
[TD]data1[/TD]
[TD]data2[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD]=IFERROR(IF(F5="","",F5/G5),NA())[/TD]
[TD]25.00%[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: right"][/TD]
[TD="width: 64, align: right"][/TD]
[TD="width: 64, align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: right"]4[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD]=IFERROR(IF(F6="","",F6/G6),NA())[/TD]
[TD]0.00%[/TD]
[TD]0[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD]=IFERROR(F7/G7,NA())[/TD]
[TD]#N/A[/TD]
[TD]blank[/TD]
[TD]blank[/TD]
[/TR]
[TR]
[TD]d[/TD]
[TD]=IFERROR(IF(F8="","",F8/G8),NA())[/TD]
[TD]Blank[/TD]
[TD]blank[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
now when i am plotting graph i am custom formatting the data labels as (#.00%;;.
but the problem here is that 0.00% and 'No Value' are treated as same. I want to display 0% but not the blank cells. how can i make the data labels do it?

Please help