How to graph functions in Excel in detail

How to graph function functions in Excel is not as difficult as you think when reading the following article. Adding function graphs will make your Excel more professional and eye-catching as well as what you want to convey to the viewer.

In Excel there are many features that users can not discover all of them Graph the function in Excel is also one of them. Charting, graphing in Excel has many types and Graph the function in Excel This is not a feature that many people are interested in because everyone knows that Excel is a tool specializing in calculating with tables and numbers.

How to graph function in Excel 2003, 2007, 2010, 2013, 2016, 2019

However, in this article, you will learn more about how to graph functions in Excel, an essential feature for those who are studying and digging deeper into Excel as well as applying it to work, not just Excel functions are still used.

Guidelines for graphing functions in Excel

Step 1: To graph the function in Excel first, please open your Excel, in this article, has examples of 2 number ranges in an equation. Of course our equation is two separate numbers rather than two axes.

How to do the Excel comparison test

Step 2: Let’s Highlight the X series in advance.

How to do the Excel comparison test

Step 3: After selecting Insert > navigate to the item Scatter and choose for yourself the graph you want.

guide to Excel comparison test in excel

Step 4: Then click vertical row of numbers are showing on your function graph.

how to know the number in Excel

Step 5: Looking to the right menu bar you fix the price Bounds So that min and max are (-5,5) as shown.

How to do the Excel comparison test

Step 6: You will be as shown below, now we continue to enter values ​​for sequence of numbers Y to enter.

How to set the number comparison in Excel 2003

Step 7: The first is to click on the section Value then select select Data.

How to do the Excel comparison test

Step 8: Here you press Add to proceed with adding value.

How to do the Excel comparison test

Step 9: Click continue on Y series value and point them to the entire Y.

How to do the Excel comparison test

Step 10: Finally press OK, got it when proceeding to add value.

How to do the Excel comparison test

As a result you have a function graph, the function graphing in Excel is complete.

How to do the Excel comparison test

And when selecting a different type to display, you will find that the function graph in Excel is more like it.

  So do the test in excel

However, this is only a function graph in basic Excel, not the form of intersecting equations or parabolic graph equations. In the next articles, will continue to perform these tips so that readers can understand more fully about graphing functions in Excel. In addition, graphing functions in Excel applies to Excel 2007, 2010, 2013 and 2016.

Converting numbers to letters in Excel is a trick that many new friends still don’t know, there are many problems required convert numbers to letters in Excel that you have to do, if you are not sure how to do it, please comment below.
Also do not forget to learn more about Excel keyboard shortcuts, graphing functions in Excel also uses a lot Excel keyboard shortcuts to eliminate lots of redundant operations.


Add a Comment

Your email address will not be published. Required fields are marked *