Do not show a portion of the data series if the value is 0

[asmithbcat]

Say I have data as follows

Apr-09 May-09 Jun-09
1.00 2.00 2.00
0.00 1.00 1.00
0.00 0.00 2.00

If the quantities I have listed are driven off of formulas, how could I not
plot the zero values.

Thanks

 

[Bernard Liengme]

Would have been nice to see the formula but I will make one up
You might have =A1/10
Change it to =IF(A1=0,NA(),A1/10)
When you make the chart, the cells with NA() (which display as #N/A) will
not get plotted
best wishes