Getting the values of the points in a trendline

Giganews Newsgroups
Subject: Getting the values of the points in a trendline
Posted by:  e.alain.le…@gmail.com
Date: 10 May 2006

Hi,

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:

Pivot table:

[AverageUse]
Month        Percentage
1              10,1234%
2              12,4678%
3              9,4373%

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:

[AverageUse]
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,

Best Regards,

Alain

Replies