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

  • Thread starter Thread starter asmithbcat
  • Start date Start date
A

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
 
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
 
Back
Top