Trendlines

[dkn]

Hi all,

I have an application that produces some reports in the form of charts / graphs. My users want trendlines adding to some of the charts, but the charting software I am using doesn't automatically support trendlines. So my alternative is to manually calculate a trendline and add it as a new lineseries to the chart.

Onto my question. Does anyone know of a function that can return a set of values to plot a trendline given a set of data?. Or, does anyone know the mathmatical equation used to calculate trendlines?

Thanks

DKN

 

[Sheco]

This might help:

http://en.wikipedia.org/wiki/Trend_line

 

[dkn]

Cheers!! I'm sure I'll be able to cobble something up from that.