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.