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
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