If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

excel charts

riam · 2003-01-09 18:44:48

i have a scatter graph in Excel with 4 points, (50,1600) (500,650) (1000,584) (5000,514), what im trying to do is select a value for y and see where it cuts the curve (and give me x). anyone got any suggestions? have searched alot but cant find anything.

Options

09-01-2003 7:44pm

#1

riam

Closed Accounts Posts: 53 ✭✭

Join Date: June 2000

Posts: 34

i have a scatter graph in Excel with 4 points, (50,1600) (500,650) (1000,584) (5000,514), what im trying to do is select a value for y and see where it cuts the curve (and give me x). anyone got any suggestions? have searched alot but cant find anything.

0

Comments

Options
#2 10-01-2003 3:54pm
thegills

Registered Users Posts: 1,802 ✭✭✭

Join Date: December 2001

Posts: 1640

Just use good ole algebra. Find the equation of each line using the 2 end-points. Then substitute the y co-ord in and out pop's the x coord.

0
Options
#3 10-01-2003 7:08pm
riam

Closed Accounts Posts: 53 ✭✭

Join Date: June 2000

Posts: 34

see its not a straight line, not sure how to get the equation of a curved line or if its possible

0
Options
#4 11-01-2003 12:31am
John2002

Registered Users Posts: 646 ✭✭✭

Join Date: October 2002

Posts: 577

Not sure if this is any help: http://mathforum.org/library/drmath/view/53569.html

I can't really remember that mathsy stuff!

0
Options
#5 13-01-2003 9:47am
riam

Closed Accounts Posts: 53 ✭✭

Join Date: June 2000

Posts: 34

thanks, i'll check that website.

0