"nygaard" wrote in message
...
In regression analysis the gradient is used for further analysis. By
hiding
values (coloumns) the number of points in the trend analysis varies and
the
gradient changes. How can the gradient values be transferred to a cell and
as
such be used in further analysis / equations ?

Assuming that you are using a linear trend line, use the LINEST() function.
--
David Biddulph