Hi,

If you have formulas you can return "" or NA but these will still be plotted
as 0 on the chart, so if you are charting a line chart there is no easy
solution.

Cheers,
Shane Devenshire

"akaka" wrote:

I have created a table that checks the date via an if statement, and if the
date is ok, then it returns the result of a formula. If the date is not ok,
then it should return nothing.
The formula I currently have is if(dateok,formula result,"").
When I chart the results, the values are 0. I have also tried #N/A, but the
chart includes the #N/A as value labels.
I would like to know if there is anything I can put at the end of the IF
statement to get the chart to not include anything, ie the same result as if
I completely delete the formula.
Thanks.