division by zero error
 

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?

division by zero error
 

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?

division by zero error
 

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?

division by zero error
 

Thanks, worked like a charm!!

"Bernard Liengme" wrote:

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?