Rather than getting the formula to evaluate to zero, get it to evaluate to
the N/A# error

=IF(Date<Today,NA(),Value)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Cruickshank Brothers" <Cruickshank
wrote in message ...
How can I suppress the plotting of zero values in line charts? The source
cells have a formula that evaluates as zero for future dates in the date
range.