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

C

CTarantino

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.
 
J

Jon Peltier

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

wanting to NOT plot #Div/0 on chart 1
We try to save msg in got the error in outlook 2021/office 365 0
Create a chart from a table in word thats dynamic 0
Employee Schedule not plotting properly - chart type / data series not correct 0
How to change series plotting order without changing legend order? 6
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
How do I plot "" as empty rather than zero in a chart 2
Problem with plot 2

Top