using charts to read off new data

[Guest]

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.

 

[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