Re: empty cells

[Jean Bréfort <jean brefort normalesup org>]

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