Graphing Linear Inequalities in Two Variables using Excel 2010

Hello all,

I'm working on an assignment where I need to graph linear inequalities in two variables. So far I've formatted the graph to my liking except for the line and shaded area. Two questions and a picture of where I'm at so far below for better understanding.

- How do I make the line continue across the entire grid while keeping the x and y intercept data points intact?
- Once the line is stretched across the grid how do I "shade" one side of the line to show the solution?

Thanks for any help you can give.

Here's what I have so far...
Capture.JPG

Thank you Andy.

I've managed to extend the line to reach both sides of the grid. But I can't seem to figure out how to shade the one side using Area chart. When I select data and choose an area chart it just creates a separate chart all together. =/

Think I'm almost there Andy,

Ive created another data series within the "select data source" dialog box. I edited nothing only choosing to "add" another series. I hit okay and red dot is now shown on (1,1).

I then right click on this data series and choose "format data series" and select "secondary axis" under Series Options. Red dot moves up somewhere in (1,3.3?).

I then right click on this series again and choose "change series chart type". I select "area" chart and the series disappears.

Am I following the steps correctly at this point? At this point I go back to "select data source" dialog box and I'm lost =/.

Thanks for the help Andy,

I just can't seem to select the right ranges in order to make it "fit" against the dotted line. I think I might just use some image editing software to created the "shade" =).

At least I have the line extended out and have a better understanding of how to use different data source series. Thanks for the help Andy. I truly do appreciate it.

Originally Posted by Andy Pope

include 2 points in your xy data that are beyond the scale. You should then get the line but no end data markers.

Use Area chart to shade below the line. Plot the series on the secondary axis. I have left the secondary axis gray so you can see it.

How would I calculate linear inequalities if I have 21 rather than two variables! I also need to calculate the weightings used to create a particularly complex data set.