If you current formula is =A1/B1, try =IF(B1="",NA(),A1/B1)
--
David Biddulph

"Tom" wrote in message
...
I have data where there is a division by zero error because nothing is
entered, but that will change when the data is entered. Is there a way I
can
suppress the chart from putting 0's in its place so that there is a gap in
the chart when there is a division by zero error?