Has anyone added a trendline to an excel chart then, set that line to forcast out a certain number of periods? The chart control in SQL Reporting Services does not have the trendline or forcast option.
I would like to populate a table with these trendline data points, including forecast, and then make a chart from that. I am looking for a way to derive these trendline data points from a given dataset.
I am looking for someone to point me in the right direction. Possible a stored procedure solution that accepts a table as input? My data will look like this.