extrapolating chart

[paul in leeds]

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

 

[Ed Ferrero]

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/tabid/102/Default.aspx

Ed Ferrero
www.edferrero.com

 

[Shane Devenshire]

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,