| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
|
#3
|
|||
|
|||
|
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. |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| replace "#DIV/0!" error with blanks | Excel Worksheet Functions | |||
| # DIV/0! error in Excel | Excel Discussion (Misc queries) | |||
| Prevent non-numerical data (e.g. text) from plotting on a chart | Charts and Charting in Excel | |||
| How do I prevent Excel from plotting a cell w/ a formula as a "ze. | Charts and Charting in Excel | |||
| How do I prevent Excel from plotting a cell w/ a formula as a "ze. | Charts and Charting in Excel | |||
Hybrid Mode
