Re: line chart breaks

You don't mention what version of XL you are using, but there is a bug
in 2002 where a break in a line chart is ignored by XL. I don't know
if it is fixed in 2003.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <uWj5qk0gDHA.1832@TK2MSFTNGP09.phx.gbl>,
maxim@NOSPAMwave.co.nz says...
> 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
>
>
>