• Around The HomeToggle Menu

    • Entertainment
    • Productivity
    • Smart Home
  • FamilyToggle Menu

    • Parenting
    • Toys
    • Pets
    • Travel
  • ReviewsToggle Menu

    • Phones
    • Tablets
    • Laptops
    • Desktops
    • Wearables
    • Audio
    • Cameras
    • Headphones
    • Printers
    • Smart Home
    • TVs
    • Gaming and Video
  • One Cool ThingToggle Menu

    • Frugal Tech
    • Kickstarters
    • Videos
  1. Home
  2. Around The Home
  3. Productivity
  4. How to Graph Inequalities With Excel

How to Graph Inequalities With Excel

By: Collier Jackson
  • Share
  • Share on Facebook

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)."

Video of the Day

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.

Show Comments

Related Articles

How to Graph Linear Equations Using Excel

How to Graph Linear Equations Using Excel

Around The Home
Productivity
By: Stephanie Ellen
How to Perform Linear Regression in an Excel Spreadsheet

How to Perform Linear Regression in an Excel Spreadsheet

Around The Home
Productivity
By: David Weedmark
How to Draw a Tangential Line in Excel

How to Draw a Tangential Line in Excel

Around The Home
Productivity
By: James T Wood
How to Switch the X & Y Axis on Google Docs

How to Switch the X & Y Axis on Google Docs

Around The Home
Productivity
By: Shawn McClain
How to Graph Complex Functions With Excel

How to Graph Complex Functions With Excel

Around The Home
Productivity
By: Amy Dombrower
How to Graph a CSV File in Excel

How to Graph a CSV File in Excel

Around The Home
Productivity
By: Kiva Bottero
  • HOW WE SCORE
  • ABOUT US
  • CONTACT US
  • TERMS
  • PRIVACY POLICY
  • COPYRIGHT POLICY
  • Advertise

An error occurred. Try again later.

Thanks for signing up!
© 2019 Leaf Group Ltd. Leaf Group Media

Get great tech advice delivered to your inbox.

Keep your family productive, connected, entertained, and safe.

Please enter a valid email.