Solved

# Excel graph for solving simultaneous equations

Posted on 2011-03-25

Need someones help to develop a graph which plots two lines for solving a simultaneous equation. Manually when the graph is plotted with when x=0 and y= a value and when x= a value and y=0 for both sets of equations.

Sample data is as below:

Eqn (1): -1x - 12y = 54

when x=0, y=-4.5 and when y=0, x= -54

Eqn (2): 4x + 3y = 25

when x=0, y=8.3333 and when y=0, x=6.25

When the two lines are plotted for the above equatons, where they cross I will need the x and y value which is the solution for the simultaneous equation.

I don't mind whether the solution uses vba or not.