line graph - blank cell with formular but plots as zero?

[exceliz]

I have a formula in a cell but the cell value is blank. on the graph it shows as zero
is there a way of not having a line at all where it is blank value?
if not i can keep my cell empty and drag down my formula each month.
Thanks
any help is appreciated.
Liz x

 

[Richard Schollar]

Hi Liz

rather than having your formula return a zero (or blank), have it return NA() as these will values will then not get plotted.

 

[exceliz]

Hi richard
Thanks for quick answer, how do I return NA?
here is my formula:
=IF(HLOOKUP(A6,ReferralsData!$B$13:$M$43,4,FALSE),I5+HLOOKUP(A6,ReferralsData!$B$13:$M$43,4,FALSE),"") - insted of "" i put NA () and it didnt work?

Thanks

HI RICHARD, sorry when i dragged the forumar to the last entry it worked!!!!!!!
THANK you vey much !