Microsoft spreadsheet help?

Question

I created a scatter plot but I need to add a linear regression line. Does anyone know how to add the line?

Answer 1

On your chart click the plotted series you want to trend, you should then see each data point of that seeries highlighted with a square. Now right click the highlighted data series and from the pop up menu select 'Add Trend Line'.

A new window will open with various trend/regression choices available on the TYPE tab. Choose what you want and click OK and a new series will be added to your chart.