How to build function graph in Excel?
Excel is a great tool for working in the office and at home. It is perfect for calculating your spending on vacation and for concluding serious financial conclusions of a large company. A whole series of our articles is already devoted to various functions of Excel. Let's look at yet another feature of this great application. So how do you build a function graph in Excel?
Plotting function in Excel
Excel allows you to build not only ordinary graphs, but even graphs of various mathematical functions. Here are the steps you need to take to plot a function in Excel:
- Open a clean sheet in Excel or create a new project.
- Create two columns. The first is to write the argument. In the second there will be a function.
- Fill in the first column, that is, in column X, such X values that would suit you for calculating and plotting the function. It is necessary to specify the segment on which the function will be built.
- In the next column you need to enter the formula of the function.According to this formula, a graph will be built.
- The "=" sign. All formulas in Excel begin with it. No need to enter the necessary formula in each line, as it is inconvenient. Excel developers have provided everything you need. For a formula to appear in each cell, you need to stretch it. To do this, click on the cell with the formula. You will notice a small square in the lower right corner of the cell. Hover the mouse over the square so that the cursor changes. Now hold down the right mouse button and drag the formula to as many cells as you need. This is necessary in Excel to build a graph of the function.
- Now you can proceed to the direct construction of the schedule. In the Menu, select the Insert tab. And in the Insert, select the diagram.
- Select any of the suggested scatter plots. Click Next. Why exactly scatter chart, and not any other? Other types of diagrams will not allow the user to create in one form both an argument and a function. The type of value accepts a reference to the group of desired cells.
- After the done actions, a dialog box appears where you need to click the Row button. Add a row using the Add button.
- The following window will appear, where you need to set the search path of values for plotting.
- To select the desired cells, click on the thumbnail image of the Excel table (after the value lines). Now simply select the desired cells from the table.
- Now, after all values are set, you need to click the "Finish" button. Here's how to build a graph of functions in Excel.
Now the schedule is built.