## Method 1 – Plotting a Linear Equation in Excel

Generally, ** linear equations** are the most common type of equation in Excel. We use them on a regular basis. Moreover, it is best for linear data. For the purpose of demonstration, we have used the following equation.

`y = 5x + 3`

Now, follow the steps accordingly.

**Steps:**

- Write down the following formula into the formula bar according to the sample equation.

`=5*B5+3`

- Press
and use the*Enter*tool to apply the formula to the whole column.*AutoFill*

- Select any cell within the data and click the
tab.*Insert* - Click on the
command from the*Scatter*group of commands.*Charts* - A drop-down menu will appear; select the first one, simply the
.*Scatter chart*

- A chart will appear. Select the chart and click on the
symbol.*+* - Click on the
as shown below.*Chart Elements*

- From the
, select*Format Trendline*and*Linear*.*Display Equation on Chart*

- Get the graph of
below.*Linear Equation*

## Method 2 – Generating an Exponential Equation in Excel

**Steps:**

- Put the following formula according to the equation we have taken.

`=EXP(B5)`

- Hit
Get the full dataset by using the*Enter*tool.*AutoFill*

- Select any cell within the data.
- Click the
tab and select the*Insert*command from the*Scatter*group of commands.*Charts* - Select the first one, simply the
from the drop-down menu.*Scatter chart*

- A chart will appear. However, select the chart and click on the
symbol.*+Â* - Click on the
as mentioned below.*Chart Elements*

- Select
and*Exponential*from the*Display Equation on Chart*.*Format Trendline option*

- The
*Exponential Equation*will appear.

## Method 3 – Creating Logarithmic Type Equation

**Steps:**

- Write the formula below and press
.*Enter*

`=LOG10(B5)+2`

- Use the
tool to do the same for the rest of the data.*AutoFill*

- Select any cell within the data.
- Click on the
tab.*InsertÂ* - From the
group of commands, select the*Charts*command.*ScatterÂ* - Select the
from the*Scatter chart*command.*ScatterÂ*

- A chart will appear. Again, select the chart and click on the
symbol.*+* - Mark the
as shown below.*Chart Elements*

- Select
and*Logarithmic*.*Display Equation on Chart*

- Get the
in the following image.*Logarithmic Equation*

## Method 4 – Plotting Equation for Polynomials in Excel

**Steps:**

- Write the following formula in the formula bar and hit the
key.*EnterÂ*

`=3*(B5^2)+5*B5-1`

- Use the
tool similarly to generate the total sample dataset.*AutoFill*

- Select a cell from the given data.
- Click the
tab.*InsertÂ* - From the
group of commands, select the*Charts**Scatter command.* - A drop-down menu will appear; select the
.*Scatter chart*

- Click on the
symbol after selecting the chart.*+* - Cick on the
as shown in the image below.*Chart Elements*

- Select
of*Polynomial*and*Order 2*from the*Display Equation on Chart*accordingly.*Format Trendline OptionÂ*

- Find the
in the below picture.*Polynomial Equation*

## Method 5 – Drawing Power Equation

**Steps:**

- Input the formula below according to the sample equation and press the
button.*EnterÂ*

`=B5^3`

- Use the
tool to complete the dataset.*AutoFill*

- Select any cell from the data.
- Click on the
tab. Moreover, click on the*Insert*command from the*Scatter*group of commands.*Charts* - Select the
.*Scatter chart*

- A chart will appear.
- Select the chart and click on the
symbol.*+Â* - Click on the
mentioned in the image below.*Chart Elements*

- From the
, select*Format Trendline Option*and*Power*.*Display Equation on Chart*

- Get the
as in the image below.*Power Y Equation*

## Method 6 – Making an Equation Based on Moving Average

**Steps:**

- Click on any cell within the data.
- Press the
tab.*InsertÂ* - From the
group of commands, select the*Charts*command.*ScatterÂ* - Select the first one, simply the
.*Scatter chart*

- Click on the
symbol after selecting the chart..*+* - Select some of the
as shown below.*Chart Elements*

- Select
and*Moving Average of Period 2*from the*Display Equation on Chart*.*Format Trendline option*

- Get the
as mentioned in the below image.*Moving Average Equation*

## How to Plot Multiple Equations on a Single Chart in Excel

Combine multiple equations into a single chart. It is as simple and quite easy as before.

**Steps:**

- Draw the
by following the steps in Method 5.*power equation* - Select the graph and press
from the filter option.*Select Data*

- Click on the
option.*AddÂ*

- Select the
and*X values*to the range for the other two equations as in the picture below. Press*Y values*.*OK*

- Press
.**OK**

- Find the three quotations plotted on the same chart.

**Download Practice Workbook**

You can download the workbook used for the demonstration from the download link below.

## Plot an Equation in Excel: Knowledge Hub

**<< Go Back to Excel Charts | Learn Excel**