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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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/
_______
 
Back
Top