El_destructo
New Member
- Joined
- Jan 28, 2015
- Messages
- 12
Hi All,
I'm trying to plot a line chart only where data exists. ie
<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
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