|Subject:||Getting the values of the points in a trendline|
|Date:||10 May 2006|
Based on a set of data, I've created a line pivot chart in Excel. I
have added a trendline, wich works perfectly! So, why this question?
Is it possible to get the specific values of a certain point on the
trendline? For example:
Now I've create a pivot chart (that's a bit difficult to reproduce with
ASCII-art;) and added a trendline, now I would like to see my pivot
table like this:
Month Percentage TrendlinePercentage
1 10,1234% 9%
2 12,4678% 13%
3 9,4373% 9%
Wich excel-guru has some briliant ideas?
Thanks in advance,