Pulling figures from a graph

Hi LiamHiggins,

To extract the slope and R-squared value from a trendline in Excel, you can utilize Excel's built-in features. Follow these steps:

1. Display the equation on the chart: Right-click on the trendline, select "Format Trendline" from the menu, and then enable the "Display Equation on chart" and "Display R-squared value on chart" options.
   Extracting data from trendline - Microsoft Community

2. Utilize the TREND function: Excel's TREND function allows you to calculate y-values based on a trendline for given x-values. This function employs linear regression to determine the result. The syntax is =TREND(known_y’s, known_x’s, new_x’s, const), where known_y’s and known_x’s represent the known x and y data in your data table, new_x’s is an array of data points for which you want to predict the y-value, and const is a binary argument for calculating the y-intercept.

Note that the TREND function acts as a dynamic array formula, automatically spilling the result for the entire array.
www.automateexcel.com