Creating a blank cell for a chart to ignore

  • Thread starter Thread starter Redsphynx
  • Start date Start date
R

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
 
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
Click to expand...

could use NA() instead of "".... =IF(E2="",NA(),F1+E2)
this will ignore that point in the plot
 
recrit said:
could use NA() instead of "".... =IF(E2="",NA(),F1+E2)
this will ignore that point in the plot
Click to expand...
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.
 
Back
Top