Line Chart with Gaps.

[El_destructo]

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

<tbody>
</tbody>

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

 

[El_destructo]

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

Broken lines

 

[El_destructo]

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.

 

[El_destructo]

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