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