Try replacing the division formula by something along these lines:
=IF(A1="",NA(),B1/A1)
The chart engine ignores N/A
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"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?