Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Division | New Users to Excel | |||
Division by Zero Error | Excel Worksheet Functions | |||
DIV/0! error in SumProduct formula with no division | Excel Worksheet Functions | |||
How can I prevent the "division by zero" error in this formula | Excel Worksheet Functions | |||
division by zero error | Setting up and Configuration of Excel |