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 ?


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.


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