extrapolating chart
hey, i want to extrapolate a number from a graph but cannot see how to do it.
i have a line graph with concentration along the bottom, and effect of change in concentration on the y axis. Is there any way i can link in some extra values in to discover the concentration of some unknown results? Thankyou Paul |
extrapolating chart
Don't use the chart, use the worksheet with the data. You can use functions
such as FORECAST. You'll have to decide what sort of line you want to use. -- David Biddulph "paul in leeds" <paul in wrote in message ... hey, i want to extrapolate a number from a graph but cannot see how to do it. i have a line graph with concentration along the bottom, and effect of change in concentration on the y axis. Is there any way i can link in some extra values in to discover the concentration of some unknown results? Thankyou Paul |
extrapolating chart
Hi Paul,
To extrapolate, right-click the series and select 'Add Trendline' Use the 'display equation' option and go from there. Otherwise, use LINEST function in your worksheet. To interpolate, download the 'Reading Interpolated Values' sample from http://www.edferrero.com/ExcelCharts...2/Default.aspx Ed Ferrero www.edferrero.com |
extrapolating chart
Hi,
1. Select the series and choose Chart, Add Trendline, select the Options tab and enter a value in the Forward box. 2. On the same tab you can use Ed's suggestion to display the equation Excel is using for the trendline. You can buld that equation in the spreadsheet and use some of the extrapolated x-values to calculate the y-values. Cheers, Shane Devenshire You can also, "paul in leeds" wrote: hey, i want to extrapolate a number from a graph but cannot see how to do it. i have a line graph with concentration along the bottom, and effect of change in concentration on the y axis. Is there any way i can link in some extra values in to discover the concentration of some unknown results? Thankyou Paul |
All times are GMT +1. The time now is 10:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com