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

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

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

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