Forum Discussion
Jiacai
Jan 30, 2024Copper Contributor
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.
Alternatively you may show trendline equation on the chart, set desired precision, and use formula for the calculations
- JiacaiCopper ContributorYes, thanks for the reminder, I found the formula. I can calculate it using the formula.
You might use the FORECAST.LINEAR function
- JiacaiCopper ContributorThanks for you advice.