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

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

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.

09-01-2003 6: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

#2 10-01-2003 2:54pm

thegills

Registered Users, Registered Users 2 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
#3 10-01-2003 6: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
#4 10-01-2003 11:31pm

John2002

Registered Users, Registered Users 2 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
#5 13-01-2003 8:47am

riam

Closed Accounts Posts: 53 ✭✭

Join Date: June 2000

Posts: 34

thanks, i'll check that website.

0