Re: line chart breaks

Hi Graeme,

Have a look at this previous thread. The code maybe useful.
(http://groups.google.com/groups?hl=...FTNGP10.phx.gbl)

Another alternative is to add a dummy data series that plots a line in
between the gaps. This line would be the same colour as the plot area.
In effect masking the real data line.
So for your data set try;
1 #N/A
2 #N/A
3 #N/A
4 4
#N/A #N/A
#N/A #N/A
7 7
8 #N/A
9 #N/A

Graeme wrote:
> Hi
>
> I use #N/A to break lines on my x-y scatter chart. Mostly works fine, but
> when I try to continue the line later (7, 8, 9 below) it doesn't cut the
> mustard. I mean I have a data source like :
>
> 1
> 2
> 3
> 4
> #N/A
> #N/A
> 7
> 8
> 9
>
> In this instance the #N/As don't work and I get a straight line between
> values 4 and 7. I can't figure what to insert in formula so have written a
> macro to clear the #N/A cells (this works, but messy, as I then need to
> repopulate cells with formula later). I tried =IF(ISERROR(Z61),"",Z61) but
> this is seen as zero value. Is there anything I can use in place of the ""
> to CLEAR the cell? Or any other techniques?
>
> Thanks
> Graeme
>
>

--

Cheers
Andy

http://www.andypope.info