+ Reply to Thread
Results 1 to 3 of 3

Do not graph negative numbers

  1. #1
    Registered User
    Join Date
    02-09-2011
    Location
    US
    MS-Off Ver
    Excel Mac 2011
    Posts
    31

    Do not graph negative numbers

    Hi all,
    What is the best way to remove negative values from a line graph? All the data should be positive but I have a few negative values that are not real data points so I don't want to graph them. I'd rather not replace them with 0's I'd prefer to just have a missing data point. all the negatives are the same number (-7999). While the rest of the graph is in the range of 1500-2200.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: Do not graph negative numbers

    Take a look at the NA() function...

    Example...

    =If(B2<0,NA(),B2)

    In this example, if B2 is negative the cell will show #N/A which will not graph
    HTH
    Regards, Jeff

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,373

    Re: Do not graph negative numbers

    I would be tempted to manually format the y axis minimum to 0. I guess this technically means the -7999 is still plotted, but it is plotted "off scale" where I can't see it.

+ 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