+ Reply to Thread
Results 1 to 5 of 5

Chart "Connect data points with line" for "Hidden and empty cells"

  1. #1
    Registered User
    Join Date
    02-03-2008
    Posts
    3

    Chart "Connect data points with line" for "Hidden and empty cells"

    Hi!

    With a line chart I'm having the following problem. I have data produced by formulas, which can produce either a value or empty. I want to make a line chart where data points are the non-empty values and the empty cells are connected by a line.

    But using the "Hidden and empty cells" option of chart, it considers the empty cells as zeros, not blanks, if the "emptiness" is returned by a formula. Is this a bug in Excel or a problem in my usage?

    Attached is a screenshot with comments, which might clarify the issue, and also the sample excel from which the screenshot was taken.

    Thanks in advance!
    Suni.
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099
    Hi,

    Is this what you are trying to do?
    Attached Images Attached Images
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  3. #3
    Registered User
    Join Date
    02-03-2008
    Posts
    3
    Hi!

    Yes, thanks, that helped! Now I get the chart neatly connected as I want. Only minor elegance issue anymore is, that I'd prefer not seeing the #N/A in the actual cells, but that's not a big thing, because those cells are anyway only used in calculation, not printed out as such.

    Thanks for the help!

    Suni

  4. #4
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099
    You could trying a Conditional format on your table, that if it displays #N/A, format font to White

  5. #5
    Registered User
    Join Date
    02-03-2008
    Posts
    3
    Thanks, I could try that.

    Suni.

+ 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