• Around The HomeToggle Menu

    • Entertainment
    • Productivity
    • Smart Home
  • FamilyToggle Menu

    • Parenting
    • Toys
    • Pets
    • Travel
  • Product 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
Techwalla
  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 Make a Graph for Density in Excel With Microsoft

How to Make a Graph for Density in Excel With Microsoft

Around The Home
Productivity
By: Jackie Lohrey
How to Make a Skew Graph in Excel

How to Make a Skew Graph in Excel

Around The Home
Productivity
By: John Papiewski
How to Graph Linear Equations Using Excel

How to Graph Linear Equations Using Excel

Around The Home
Productivity
By: Stephanie Ellen
How Do I Create a Polygon Frequency Graph Using Excel?

How Do I Create a Polygon Frequency Graph Using Excel?

Around The Home
Productivity
By: Lee Johnson
How to Calculate Domain & Range on a Graphing Calculator

How to Calculate Domain & Range on a Graphing Calculator

Around The Home
Productivity
By: Lee Johnson
How to Build a Pyramid Graph in Excel

How to Build a Pyramid Graph in Excel

Around The Home
Productivity
By: Cooper Temple
  • 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.