Getting the trendline equation - Regression analysis

[Daniel Setterwall]

Hi,

I would like to create a macro/application in Excel where a set of data is transfered to a chart, and the trendline equation is calculated with a given number in a cell. I know how to create the chart, but how do I get the trendline equation?