Hi,

Use NA(). The will cause the data marker to be omitted. Note the line will
be interpolated between valid data points.
Something like this,

=IF( <test , <value , NA() )


Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"sarcastix" wrote in message
...
I want to suppress chart points for a cumulative line graph of monthly
telephone costs where the particular month's values have not yet been
entered
but there is a formula in the cell which currently returns null but will
return the value once it is posted on the accountmaster sheet.