+ Reply to Thread
Results 1 to 4 of 4

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

  1. #1
    CTarantino
    Guest

    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. #2
    Jon Peltier
    Guest

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

    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. #3
    curious
    Guest

    Re: 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.

    >


  4. #4
    Andy Pope
    Guest

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

    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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1