division by zero error

[Guest]

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?

 

[Bernard Liengme]

Try replacing the division formula by something along these lines:
=IF(A1="",NA(),B1/A1)
The chart engine ignores N/A
best wishes

 

[David Biddulph]

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

 

[Guest]

Thanks, worked like a charm!!

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