Line Chart with Gaps.

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Line Chart with Gaps.

  1. #1
    New Member
    Join Date
    Jan 2015
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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

User Tag List

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