extrapolating chart


P

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
 
Ad

Advertisements

D

David Biddulph

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.
 
Ad

Advertisements

S

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top