How to graph Inequalities and Shade by itself? Also finding intersection points

Can anyone help?

Hey I checked your attached file but still this problem is not so cleared to my mind so I will let you know about its solution ASAP.

Originally Posted by James Donovan

Hey I checked your attached file but still this problem is not so cleared to my mind so I will let you know about its solution ASAP.

Each table I have in my spreadsheet corresponds to the inequality I used(top of table is the inequality I used). The arrow pointing at that trapezoid figure in the graph, is the one I need to shade automatically, because that part of the graph is the only part that makes all inequalities true.

Thanks, any help will be good

I know I've seen this described before here. IIRC, it involves plotting the data twice in a combination scatter and area chart. One data series is plotted as scatter and the other is plotted as area.

Finding the intersection point is as simple as solving the system of equations. I don't know what method you prefer (you might review any of the online tutorials for solving systems of equations if you need help), but, once you understand your preferred solution method, programming that into the spreadsheet should be relatively easy.

I forgot to mention that in my spreadsheet, some of the inequality functions depend on cells F2:F6, so if they change the graph will change.

I found the intersection points of the lines using goal seek only if I use those values of cells F2:F6, how can I make the goal seek automatic.

For example, the equation on the goal seek cell is dependent on some of the values F2:F6, I want to let goal seek equal always be equal to 0 on cell "C60" by changing cell "B60", if the values of F2:F6 are changed.

What online tutorials are you talking about, so I can take a look.

Here's one http://www.purplemath.com/modules/systlin1.htm and, if you don't like that one, put "solving systems of linear equations" or similar into your favorite search engine.

I found the intersection points of the lines using goal seek only if I use those values of cells F2:F6, how can I make the goal seek automatic.

Automating the goal seek utility will require a macro associated with the change/calculate events. All of your lines are straight lines, so using algebra (as explained in any good algebra course/tutorial) you should be able to find an algebraic expression for the point(s) of intersection and program that into the spreadsheet to be automatic.

I never "shade" parts of a graph like that, so I'll let someone else who is more skilled at that exercise explain how to do it.

Originally Posted by MrShorty

Here's one http://www.purplemath.com/modules/systlin1.htm and, if you don't like that one, put "solving systems of linear equations" or similar into your favorite search engine.

I tried it out, but did not succeed on finding the intersections points, is it possible for you to make an excel spreadsheet of 2 basic linear lines that intersect at one point?
The only way I could was using goal seek, but will give me the wrong intersection points, If I change the graph, because goal seek wont reset to 0.

But thanks

I came across this tutorial for shading parts of an XY scatter graph http://peltiertech.com/WordPress/fil...a-combo-chart/ See if that helps with that part of the problem.

What part or step in solving a system of equations did you get stuck on?