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

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

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

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"asmithbcat" wrote in message
...
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