Excel is an excellent tool for plotting equations in a graph as it offers various types of graphs and many customizing features. If you are wondering how to graph two equations in Excel, you have come to the right place. Today I will show you how to graph two equations in Excel with 3 easy steps.

**Download Practice Workbook**

Download this practice workbook to exercise while you are reading this article.

**3 Easy Steps to Graph Two Equations in Excel**

Let’s say we have two equations like these below:

**f(x)=x^2+3**

**g(x)=3x+5**

And now, we want to plot both equations in Excel in a single graph. To do this, follow the steps below.

### Step 01: Create a Table with Proper Parameters

- To graph equations in Excel, firstly, we have to make a data table containing a specific range of x values and find their corresponding values of f(x) and g(x).
- Hence, first, open a blank excel sheet.
- Secondly, choose any suitable position to give the heading x. Under the heading x, a range of x values will be listed. (see the figure below)
- Thirdly, write the two equations in the two adjacent cells.

- Here we have chosen
**B4**,**C4,**and**D4**for**x**,**f(x),**and**g(x),**

**Read More: ****How to Create Equation from Data Points in Excel**

### Step 02: Make a List of Values of X, F(x), G(x)

- Now we have to choose a range for values of x.
- Here we have chosen -5 to +5, a total of 11 points. You can choose at your convenience.

- Then, we will put the formula in the corresponding columns of f(x) and g(x).
- In cell
**C5,**under the heading of**f(x)**, write down the formula:

`=B5^2+3`

- You will get 23 as a result. This is the value of f(x) when x= -5. (See the figure below)

- Now, use the
**Fill Handle**to**AutoFill**up to**C15**

- This will give all the corresponding values of f(x) for each value of x.

- Now write down the following formula in cell
**D5**under**g(x)**

`=3*B5+5`

- You will get the value of
**g(x)**for x=-5. - Then use the
**Fill Handle**to**AutoFill**up to**D15**.

- So up to this, we have successfully prepared our table to plot the graph.

**Read More: ****How to Show Equation in Excel Graph (with Easy Steps)**

### Step 03: Create a Scatter Plot from Two Equations

- Select cell
**B4**to**D15** - Now, click on the Quick Analysis tab at the bottom of the D15 cell. Alternatively, you can also type
**Ctrl+Q**to launch this Tab.

- Here, you will see different tabs. Click on

- Under the charts, click on
**Scatter**. And here, we got our desired graph for two equations.

- As the legends suggest, the blue curve is for
**f(x),**and the orange curve is**g(x)**. - This is the quickest way to plot a chart.
- Furthermore, there is an alternative that offers much more flexibility than this approach.
- In the alternative approach, after selecting the data table, go to
**Insert**Tab; click on the**Scatter**plot in the**Chart**Now, choose any suitable style for the scatter plot.

- In this way, you will get the same result.

**Read More:** **How to Create Equation from Data Points in Excel**

**Things To Remember**

- In addition to this, we can further customize it and add other elements such as
**Axis Titles**,**Chart Titles**,**Data Labels**,**Error Bars**, and**Trend Line**to enhance the representation of our chart.

**Conclusion**

This is the end of this article. Thanks for reading. If you find this article helpful, please share this with your friends. Besides, do let us know if you have any further queries. Finally, please visit **Exeldemy** for more exciting articles on **Excel**.

## Related Articles

**How to Get Y Equation on Excel Graph (6 Ways)****Find Unknown Value on Excel Graph (4 Easy Ways)****How to Find the Equation of a Line in Excel (With Quick Steps)****Display Equation of a Line in Excel Graph (2 Easy Ways)****How to Determine Protein Concentration from Standard Curve in Excel****Calculate Unknown Concentration from Standard Curve in Excel**