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.