If I have some data in an scatter plot in Excel, e.g.
X Y 1 10 2 20 3 30 4 40 5 50
and I want to find the Y value for X = 10, or X=3.5, or whatever (obviously this is a simplified example) I've been doing the following:
- Add a trend-line to the scatter plot data
- Format the trend-line to one that fits the data (linear in this case)
- Display the equation for the trend-line on the chart
- Type the equation into an empty cell, replacing x with a cell reference. E.g. "
=10*A1" then put my X value into the cell A1
Is there a better way of doing this with Excel? It's quite a few steps, and fairly repetitive. Or maybe Excel is just a poor choice of application for doing this?
(I'm using Excel 2007)