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

[NorTor]

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 Ogilvy]

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

 

[NorTor]

Tom,

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


regards,
-Tor Olav