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.
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/
_______
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.
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.
>
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks