Chart Problem

  • Thread starter Thread starter pcor
  • Start date Start date
P

pcor

HI
I have 4 col of data
Col A,B and C contain Numbers
Col D contains this formula. =if(a1=0,"",(a1+b1+c1)/3)
I current have data in 12 rows
I copied the formula from Col D all the way down to row 25.
This will accomodate future data.
I chart the data in Col D and all is ok as long as there in Data in Col A
With No data in col A the response in Col D is a blank. That is OK
BUT THE CHART SEEMS to translate that to ZERO
How can I avoid the ZERO in the chart
Help
 
You can use the NA function in your formula, instead of an empty string:

=IF(A1=0,NA(),(A1+B1+C1)/3)
 
Back
Top