Line Graph Problems - It works in Lotus !!!!!!
Posted by Nick Limbrick on October 12, 2000 5:39 AM
I have just switched from Lotus 123 to Excel.
In Lotus I had a line graph generated from a list of formulas.
Some of the formulas give an error message as no data is available for those points and the line graph does not plot the points. Great that's what I want.
In Excel however the formulas give #DIV/0! message and the line grpah treats them as zeros and plots them.
Without running a macro or manually clreaing out the errored formulae is there any way of stopping them being plotted.