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
<tbody>
</tbody>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
e.g.
A - 25.00%
B - 0.00%
D - #N/A
E - No Value
serier | formula | calculated_value | data1 | data2 | ||||
a | =IFERROR(IF(F5="","",F5/G5),NA()) | 25.00% |
<tbody> </tbody> |
<tbody> </tbody> | ||||
b | =IFERROR(IF(F6="","",F6/G6),NA()) | 0.00% | 0 | 4 | ||||
c | =IFERROR(F7/G7,NA()) | #N/A | blank | blank | ||||
d | =IFERROR(IF(F8="","",F8/G8),NA()) | Blank | blank | 4 | ||||
<tbody>
</tbody>
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