Current location - Loan Platform Complete Network - Foreign exchange account opening - How to make supply demand diagram with excel
How to make supply demand diagram with excel
Hello, the specific steps are as follows.

1. First, create a new EXCEL chart.

2. Take column A as independent variable X and column B as dependent variable Y. First, we enter the range of independent variable X in column A..

3. Next, edit the formula. The function is y = 2x 2+4. Click on table B 1 and enter the function formula in the red circle. It should be noted that you cannot directly enter y = 2x 2+4, but enter = ABS((a 1)2 * 2)+4), which is a fixed format of the formula and must be strictly observed. It should be noted that this is similar to entering a calculation formula in a calculator. Parentheses and operation symbols cannot be omitted, and the independent variable x is replaced by A 1 Click Enter after input, and the calculation is completed.

4. When the cursor is pulled down, calculate the value in the domain of the dependent variable y..

5. Select Insert-Chart-Line Chart in the toolbar. The subgraph can choose what it needs. Click Finish to get the required functional image.