Creating a blank cell for a chart to ignore
 

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

Creating a blank cell for a chart to ignore
 

On Jul 9, 7:21*pm, Redsphynx
wrote:
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

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

Creating a blank cell for a chart to ignore
 

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


"recrit" wrote:

On Jul 9, 7:21 pm, Redsphynx
wrote:
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

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

Creating a blank cell for a chart to ignore
 

"recrit" wrote:

On Jul 9, 7:21 pm, Redsphynx
wrote:
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

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.