Forum Discussion
Conor Davies
Feb 28, 2018Copper Contributor
Set trendline intercept to cell value from spreadsheet
Hi,
I have an exponential decay data set, and want to force the y-intercept to take one of the values from the data set (the initial reading).
How can I set this up so that if new data is added, the intercept changes depending on the first value in the results table, please?
Can it be done easily or is it only possible via manual entry when 'formatting trendline'?
Many thanks in advance.
Conor
1 Reply
- Conor DaviesCopper ContributorLots of views but no reply - is this a reasonable question or an impossible ask?
Thanks in advance.
Conor