Can I prevent a #DIV/0! error from plotting on a chart
 

Is it possible to force an error (like #DIV/0!) to plot as if there was no
information in the cell? It seems like the default is to plot the error as a
zero.

Text values (including "") and most errors are plotted as zero. If you
can detect the error in a formula, convert it to #N/A, and many chart
types will just interpolate past the missing point.

=IF(ISERROR(A1/A2),NA(),A1/A2)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


CTarantino wrote:

Is it possible to force an error (like #DIV/0!) to plot as if there was no
information in the cell? It seems like the default is to plot the error as a
zero.

But what if I want gaps instead of interpolation? Please advise. Thanks.

"Jon Peltier" wrote:

Text values (including "") and most errors are plotted as zero. If you
can detect the error in a formula, convert it to #N/A, and many chart
types will just interpolate past the missing point.

=IF(ISERROR(A1/A2),NA(),A1/A2)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


CTarantino wrote:

Is it possible to force an error (like #DIV/0!) to plot as if there was no
information in the cell? It seems like the default is to plot the error as a
zero.

Hi,

You have to use a work around to mask the gaps.
http://www.andypope.info/charts/brokenlines.htm

Cheers
Andy

curious wrote:
But what if I want gaps instead of interpolation? Please advise. Thanks.

"Jon Peltier" wrote:


Text values (including "") and most errors are plotted as zero. If you
can detect the error in a formula, convert it to #N/A, and many chart
types will just interpolate past the missing point.

=IF(ISERROR(A1/A2),NA(),A1/A2)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


CTarantino wrote:


Is it possible to force an error (like #DIV/0!) to plot as if there was no
information in the cell? It seems like the default is to plot the error as a
zero.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info