Hi,
Is there any way to not to show an axis label if value is zero against that?

suppose if a table is like below

Data Value

A 3
B 5
C 0
D 7
E 2



If i want to not to get the graph of C in axis, what to do?

I know that, I can hide that column if the graph is not to be shown for that. I cant use that since its a highly dynamic data and I dont want to go and hide it everytime
and I can use the formula like
PHP Code: 
=if(A1<>0,A1,"") 
. But it will leave a gap in the graph where it was supposed to be.

Any other options?