Results 1 to 4 of 4

Line Chart with Gaps.

This is a discussion on Line Chart with Gaps. within the Excel Questions forums, part of the Question Forums category; Hi All, I'm trying to plot a line chart only where data exists. ie 1 #n/a 2 #n/a 3 51 ...

  1. #1
    New Member
    Join Date
    Jan 2015
    Posts
    12

    Default Line Chart with Gaps.

    Hi All,
    I'm trying to plot a line chart only where data exists. ie

    1 #n/a
    2 #n/a
    3 51
    4 52
    5 53
    6 #n/a
    7 #n/a
    8 45
    9 43
    10 #n/a

    The #n/a (=NA()) works at the beginning and end of my line graph but draws a line between 5(53) and 8(45).

    Is there a way to not draw the joining line between the two?
    I've set Hidden and Empty cells to gaps but this doesn't work for mid table gaps.

    Any thoughts?

    Thanks,
    El-d

  2. #2
    New Member
    Join Date
    Jan 2015
    Posts
    12

    Default Re: Line Chart with Gaps.

    Have seen this but is a massive hack that doesn't really work that well.

    Broken lines

  3. #3
    New Member
    Join Date
    Jan 2015
    Posts
    12

    Default Re: Line Chart with Gaps.

    Interestingly. In my series, I have several #n/a 's . If I delete one of them it leaves a gap or if I delete them all then it leaves a gap.

    I was under the impression =na() was good practice when wanting to fill nothing into a cell.

  4. #4
    New Member
    Join Date
    Jan 2015
    Posts
    12

    Default Re: Line Chart with Gaps.

    FYI - for anyone who stumbles across this. Appears that you can't do it.

    You can vote for a fix...hopefully 1 day.


    https://excel.uservoice.com/forums/3...sheet-function

    further info

    Mind the Gap - Charting Empty Cells - Peltier Tech Blog


    El-d

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com