| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Non Linear Scatter plot, need to find y value
If you are happy with a linear interpolation, then paste
=FORECAST(D2,OFFSET($A$1,MATCH(D2,$A$2:$A$11),1,2, 1),OFFSET($A$1,MATCH(D2,$A$2:$A$11),0,2,1)) into E2 in the "Mine" sheet and copy down. It has exactly the same effect as the "Done" sheet. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mixing scatter plot with a category plot | Charts and Charting in Excel | |||
| Adding a linear equation to my groovy scatter plot. | Charts and Charting in Excel | |||
| how do I find the equation of a line using a scatter plot? | Charts and Charting in Excel | |||
| Can I copy x-y scatter plot data direct from one plot to another? | Charts and Charting in Excel | |||
| How do I plot a scatter plot in 3 axies? | Excel Programming | |||
Hybrid Mode
