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

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

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" wrote in message
...
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

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

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"
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