How to set X to read Y value on trend line?

Line chart and trend line, I want to read the X,Y values through the trend line.

4 Replies

You might use the FORECAST.LINEAR function

Alternatively you may show trendline equation on the chart, set desired precision, and use formula for the calculations

Yes, thanks for the reminder, I found the formula. I can calculate it using the formula.

Thanks for you advice.