Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Chicago, Illinois, USA
    Posts
    187
    Thanks
    6
    Thanked 0 Times in 0 Posts
    I'm using an IF statement to copy numbers from one column into another based on the set conditions.

    =IF(OR(D3>I3,D3<H3),D3,"")

    The formulas works fine but when I graph it, cells that fail the test contain "" but plot as zero. Adjusting the HIDDEN and EMPTY CELLS option to: SHOW EMPTY CELLS AS: GAPS still plots zeroes.

    Is there any way to not plot the blanks??? This is part of a template that needs to be operator insensitive. No manual solution (ie: copy, paste special, values)

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Instead of a null use a #NA error
    =IF(OR(D3>I3,D3<H3),D3,na())


    This will be ignored by the chart and the point will be interpolated if a line is drawn.

    As you notice a null (or any text, or error other than #NA) will be plotted as a zero on a chart. There is no way to break the line with a formula, you can only do that with a blank cell.

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Chicago, Illinois, USA
    Posts
    187
    Thanks
    6
    Thanked 0 Times in 0 Posts
    THANX, worx grate.

Posting Permissions

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