|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 26th, 2005, 03:21 AM
|
|||
|
|||
Can I prevent a #DIV/0! error from plotting on a chart
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. 
|
|
#2
August 26th, 2005, 08:35 AM
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| replace "#DIV/0!" error with blanks | Mark B | Worksheet Functions | 0 | June 22nd, 2005 10:19 AM |
| How do I prevent Excel from plotting a cell w/ a formula as a "ze. | Hatchet_Jack | Charts and Charting | 1 | February 9th, 2005 10:31 PM |
| How do I prevent Excel from plotting a cell w/ a formula as a "ze. | Bearclaw Chris | Charts and Charting | 0 | February 9th, 2005 04:59 PM |
| Formula Help | Diana HIgh School | General Discussion | 6 | November 18th, 2004 05:19 AM |
| DIV/0 | wiredbliss | General Discussion | 2 | August 14th, 2004 09:02 AM |
Linear Mode
