Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

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

Copper Contributor

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

Jiacai_0-1706593290129.png

 

4 Replies

@Jiacai 

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

image.png

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