Re: empty cells




Le jeudi 25 octobre 2007 à 22:18 +0200, jouke hijlkema a écrit :
Hello all,

I'm VERY new to spread sheets and I have the following problem. I have 
data collected over a year in irregular intervals. So I have one column 
with all the days of a year and several columns with sparse data. Now I 
want to make an XY plot using splines to interpolate. This works well if 
I  select non empty cells by hand. But not if I simply select the first 
and another column. Is there a way to do this automatically ?

Jouke

At the moment, interpolations in scatter plots don't work when data are
missing. Which version are you using? Most recent have an interpolation
sheet function which might help you.

Regards,
Jean




[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]