Creating a blank cell for a chart to ignore

[Redsphynx]

Hi,
I need to use this formula for my charts, =IF(E2="","",F1+E2)
but what I need it to do is to ignore these blank cells until there is a
false response.

At the moment my chart is plotting these as $0.00 right along the bottom of
the chart, and what I need is for it not to display until an amount is in the
cell.

Thanks,
Craig

 

[recrit]

Hi,
I need to use this formula  for my charts, =IF(E2="","",F1+E2)
but what I need it to do is to ignore these blank cells until there is a
false response.

At the moment my chart is plotting these as $0.00 right along the bottom of
the chart, and what I need is for it not to display until an amount is inthe
cell.

Thanks,
Craig

could use NA() instead of "".... =IF(E2="",NA(),F1+E2)
this will ignore that point in the plot

 

[Redsphynx]

Thanks heaps, this has been driving me nuts for the last few days!!

 

[jgenzano]

could use NA() instead of "".... =IF(E2="",NA(),F1+E2)
this will ignore that point in the plot

Thanks, this is a lot better than plotting zeros! It is only a partial
solution, however, and the plot line is still connected across that point,
instead of being a "gap" as it would be if the cell were truly blank. I
really need to get a blank cell to show that the value is missing.