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

  • Thread starter Thread starter NorTor
  • Start date Start date
N

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
 
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
 
Tom,

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


regards,
-Tor Olav
 
Back
Top