Maybe I'm being a bit slow, but can anyone give me the mathematics which Excel uses to generate the equation on the linear trendline? I have a set of data, of which I have generated a bar chart, with a linear trendline. The critical value for me is the slope, or "m" in the equation, y=mx+C. When I display the equation on the chart, I would like to automatically display the m (slope) in a cell, so that I can compare various slope or gradients. The formula Slope does not give the same value as the linear equation does. Also, as I add data, the trendline changes, and also the gradient. So I can't just copy the m-value into a cell. It needs to be automatically updated. Any suggestions???
Cheers,
Andymann
Cheers,
Andymann