line charts - error in series should not plot (empty)

Hello,


I have a slight problem when making line graphs and there is an error
value in the data series (Y-axes-values).

For instance, if there is a division by zero or some other error, I
would like the line chart to not plot (leave holes in the graph line).

Also, for zero-values I would like to not plot values but rather leave
gaps.

Is there a way to solve this please?


Best regards,
Tor Olav
Aalesund, Norway

You would have to use formulas to produce the results you want. Plotting
of Blanks or #N/A can be controlled with the setting in
Tools=>Options=>Chart tab

--
Regards,
Tom Ogilvy

"NorTor" <[email protected]> wrote in message
news:[email protected]...
> Hello,
>
>
> I have a slight problem when making line graphs and there is an error
> value in the data series (Y-axes-values).
>
> For instance, if there is a division by zero or some other error, I
> would like the line chart to not plot (leave holes in the graph line).
>
> Also, for zero-values I would like to not plot values but rather leave
> gaps.
>
> Is there a way to solve this please?
>
>
> Best regards,
> Tor Olav
> Aalesund, Norway
>

Tom,

Thank you for your help once again.
I will try to solve this the way you suggested.


regards,
-Tor Olav


On Wed, 10 Aug 2005 09:09:34 -0400, "Tom Ogilvy" <[email protected]>
wrote:

>You would have to use formulas to produce the results you want. Plotting
>of Blanks or #N/A can be controlled with the setting in
>Tools=>Options=>Chart tab