Displaying a trend line (in line chart) in SSRS

We have a line graph which plots the actual data points (x,y), everything is working fine with this graph. Now we need to add a trend line to this existing graph after going thro. the articles we came to know that there is no direct option in SSRS to draw a trend line. So we need to calculate the trend values ourselves which we need to plot as atrend line. This trend line is similar to the trend line which comes in Excel chart, do anyone know how to calculate the trend values from the actual data points. We got through several formulas, but were not clear, have anyone tried out exactly the same, if so please help us out by providing an example to calculate the trend values.

The default functionality of Reporting Services does not support trend lines. There are some additional tools you can purchase to achieve this though, which is talked about in the first link below.

You can take a look at this post: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1148970&SiteID=1
and this one: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=322398&SiteID=1

Jarret

Display data in pie charts.

Is there a way to display the actual numeric values on the pie chart for each
part?
Thanks,
Leon.Yes
right click on the pie chart, select properties, Data Tab, in the Values
click one select editm point labels tab, show point labels, stick an
expression in if you like. repeat for all values.
Greg
"Leon Chuck Gosslin" <LeonChuckGosslin@.discussions.microsoft.com> wrote in
message news:B6B349E1-4623-4DF6-9A91-6628187DFF2A@.microsoft.com...
> Is there a way to display the actual numeric values on the pie chart for
> each
> part?
> Thanks,
> Leon.