How to Graph Inequalities With Excel

Microsoft Excel is a useful program to help young students learn math. If you need to put together a worksheet with inequalities, you can use Excel to create a table of data points from an equation and then use the graph tool to display that equation graphically. To build an accurate graph, you will need a basic understanding of Excel functions, but even beginners will find the process fairly easy.

...
Teach students about inequalities using Excel.

Step

Create a column of data points in the "A" column. These data points should be evenly spaced apart but can be as small or as large as you want, depending on the range and domain of your graph. If you are unsure, using the numbers “-10” to “10” usually will suffice.

Step

Enter the equation of the inequality in cell "B1" and replace "x" with "A1." For example, if your inequality is y<3x, you would enter "=3*(A1)."

Step

Copy the contents of cell "B1."

Step

Paste the equation into the reset of the cells in the "B" column that correspond to your data points in the "A" column.

Step

Select both the data point cells and the equation cells.

Step

Click on "Line" under the Charts section of the Insert tab.

Step

Select the "2D line graph" option.

Step

Click on "Shapes" above the Illustrations header and select the "Freeform" tool.

Step

Draw a polygon that runs along the edge of the plotted line and along the edges of the chart area. Make sure it is placed properly above or below the equation, depending on the inequality.

Step

Select the polygon, click on the "Format" tab, click on "Shape Fill" and select "More Fill Colors."

Step

Adjust the color and transparency so that the shape shows up clearly on the graph.