Scatter Chart - Display Average Trendline Value?

[microwin88x]

Hello.

Is there any way to display the Average Trendline Value in the chart, next to the line?

Because the chart only shows me the line.

Thanks!!!

PS: The trendline has been set in Expressions tab and checking the Average trendline

[jerem1234]

Go to expressions where you checked the average and then select Average (should highlight in blue). Then check Show Equation.

Hope this helps!

[microwin88x]

Thanks jerem1234. I've tried that but it shows me: y = 0.0022487 and my Y axis is time (hh:mm:ss)

[Nicole-Smith]

You can use Text in Chart on the Presentation tab to calculate the average yourself and show it on the chart (use CTRL+Shift to move the text box around).