using charts to read off new data

H

HKD

I've created a chart with a linear trendline as a standard graph. I would like to use the trendline to read the x values for new data (y- values). Is there a function that can do this and how can it be done without altering the original graph.
 
J

Jerry W. Lewis

Use worksheet functions. Any of the following will do
- Slope and Intercept
- Forecast
- LinEst
- Trend

Jerry
I've created a chart with a linear trendline as a standard graph.
I would like to use the trendline to read the x values for new data
 
Top