+ Reply to Thread
Results 1 to 5 of 5

Graph line falls to zero

  1. #1
    Registered User
    Join Date
    07-30-2004
    Posts
    7

    Graph line falls to zero

    Hello.

    I have a graph (type line) corresponding to a list of values in a range of cells: B1; B2; B3

    The values of these cells are calculated based on the values of other cells: X1; X2; X3
    Values: 40; 45; "empty" (no value)

    Thus, the value of cell "B3" is equal to ... nothing, nothing visible but the cell has the function "= X3"

    Now the problem:

    I create a chart (type line) and the curve goes up to cell "B2", in cell "B3" the curve falls to zero.
    I would like the end of the graph line in cell "B2" and do not fall to zero because, in fact, the value of cell "B3" is not zero ... is nothing (empty), but Excel interprets the cell (with a function resulting in empty cell) as if it was zero ...

    Please, is there a solution for this?

    Thanks a lot,
    Gil

    [email protected]
    Attached Images Attached Images

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Graph line falls to zero

    If the formula in B3 is =X3, and X3 is blank, then B3 contains the number zero, not 'nothing.' You may have suppressed display of zeros, but it's still there as far as Excel is concerned.

    You could change the formula to =if(x3<>"", X3, na())
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    07-30-2004
    Posts
    7

    Re: Graph line falls to zero

    Thanks for your reply. Helped much.
    The problem of the graph is solved!

    However, and I'm sorry to bother you again, the list of values is not ... "beautiful" with "#N/A" in the cells.
    Is there any way to hide this information (I tried "Conditional Formatting" but without success)

    Thank you,
    Gil

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Graph line falls to zero

    Use conditional formatting so that the font color is the same as the cell color:

    CF Formula is: =ISNA(A1)

  5. #5
    Registered User
    Join Date
    07-30-2004
    Posts
    7

    Re: Graph line falls to zero

    Done !

    Thanks a lot
    Gil

+ 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