This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

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.

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.

That said, Excel can't plot equations, since it's not a TI calculator. The closest you can get is to do a line graph with a few sample points - since these are linear equations, that shouldn't be too difficult to give it a few example pairs and have it graph them for you.

It won't calculate the intersection though - it's not really designed to do that, so you'll have to do it by hand using substitution.

That's the difficulty I am having at the moment is trying to understand how to get two lines to plot on one graph from separate datasets.

Simultaneous-Equations.xlsx

Travis

Insert tab > Scatter > select one of the last two types.

This will plot the two lines for you.

The problem in this particular example is that the intersection point does not lie on any of the two line segments plotted. They will both have to be extended so that the intersection point is evident

I have modified your range as explained above and plotted a chart in the attached file.

I have also created a similar range and included the intersection point in it and then plotted it to show the intersection point.

Saqib

Copy-of-Simultaneous-Equations.xlsx

Must this be an Excel solution? If not, have you considered the (free) (Microsoft Mathematics 4.0? This seems to do everything you want "out of the box".

Regards,

Brian.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.

Simultaneous-Equations.xlsx