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
Bookmarks