ExcelBanter - How do I get an intermediate value between data points on a graph?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I get an intermediate value between data points on a graph? (https://www.excelbanter.com/excel-discussion-misc-queries/71021-how-do-i-get-intermediate-value-between-data-points-graph.html)

bman in co

How do I get an intermediate value between data points on a graph?

I have a set of x,y data points and I need to find/use a value between the
known x values. How can I get this info acurately and into a cell so I don't
have to scale it off the graph?

Gary''s Student

How do I get an intermediate value between data points on a graph?

The FORECAST() function does an excellent job of interpolation.

See the Help description
--
Gary''s Student

"bman in co" wrote:

I have a set of x,y data points and I need to find/use a value between the
known x values. How can I get this info acurately and into a cell so I don't
have to scale it off the graph?

All times are GMT +1. The time now is 02:29 PM.