+ Reply to Thread
Results 1 to 3 of 3

Chart+named ranges: undesired points show up at y=0 - problem

  1. #1
    Forum Contributor
    Join Date
    04-24-2012
    Location
    Moscow
    MS-Off Ver
    Excel 2010
    Posts
    291

    Chart+named ranges: undesired points show up at y=0 - problem

    Hi all!!

    Partially following Ace_Xl advise, i plot a scatter when data source refers to named range which is refers to data according to a formula - =if(column A=..,column B,"") where column B is y variable. The problem is that unsuitable points from column B still show up but as 0, I've tried a lot of staff so please, if you know exactly how to solve it, I'll appreciate that much! And sorry again for not uploading - i just cant

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Chart+named ranges: undesired points show up at y=0 - problem

    revise formula to use NA() instead of "", which will be treated as zero in a chart.

    =if(column A=..,column B,NA())
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    04-24-2012
    Location
    Moscow
    MS-Off Ver
    Excel 2010
    Posts
    291

    Re: Chart+named ranges: undesired points show up at y=0 - problem

    Andy Pope - YOU'RE GENIUS!!!!!!!!!!!!!!!! thnx

+ 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