PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting Re: line chart breaks

Reply

Re: line chart breaks
 
Thread Tools Rate Thread
Old 25-09-2003, 12:23 PM   #1
Jerry W. Lewis
Guest
 
Posts: n/a
Default Re: line chart breaks


Clearing the cells (either manually or by macro) is the only solution
until MS adds a true missing value (don't hold your breath).

Jerry

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
  Reply With Quote
Reply

Archive


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off