Trendline on Scatter Chart

[#1]

Hi - is it possible to add a trend line to a scatter chart? I would also like to display the formula and R-Sq value. See example below. Thanks in advance!

[Anonymous · Accepted solution]

I guess a good start would be to take a look at the expression tab of the chart. Once there, select an expression and check the box for the appropriate trendline (bottom of the same tab). There you can also select to display the expression and the R2 value. (Although for some reason that I don't understand the expression will not always display even if checked...)

[#3]

Thanks Michael.

[#4]

I cannot get a trendline on a scatter chart in version 10 SR1. Are you getting the same result in 10?

Thanks

Larry