Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Show Equation in Excel Graph (with Easy Steps)

In Excel, graphs are so much important to visualize data or results after any kind of operation. Most of the time, for business purposes, there is no need to show equations of the graphs. But for academic or research purposes, we need to show equations to forecast or understand what trend is the chart following. So, in this article, we are going to discuss how to Show Equation in Excel Graph.


Download Practice Workbook

Download the practice workbook and practice yourself.


3 Easy Steps to Show Equation in Excel Graph

Showing Equation in Excel Graph is a simple way. You can easily Show the Equation in Excel Graph by following some easy steps. However, let’s take a dataset of Sales Reports on ABC Traders. The dataset has 2 columns called B & C where the columns indicate Days and Sales respectively. The dataset ranges from B4 to C12. Here, In this portion of this article, I will show 3 easy steps to Show Equation in Excel Graph. Hope you will understand the steps easily and enjoy the article.

How to show equation in excel graph


Step 1: Insert a Scattered Chart

  • First, Select the data table ranging from B5 to C12.

Insert a scattered chart to show equation in excel graph

  • Then, Go to the Insert tab in your Toolbar.
  • After that, Select the Scattered Plot
  • Hence, Select the first option of the scattered plot.

Insert a scattered chart to show equation in excel graph

  • As a result, you will find your graph like the one below.

Insert a scattered chart to show equation in excel graph

Read More: How to Graph Two Equations in Excel (with Easy Steps)


Step 2: Add a Trendline in Graph

  • Click on the graph first.
  • Then, Select the “+” icon on the right side of the graph.
  • After that, Select the options Axis Title, Chart Title & Trendline.
  • Go to the More Options to add the equation.

add a trend line to show equation in excel graph

  • After changing the Titles your graph will be just like the one given below.

  • A window will pop up on the right side of the graph after clicking more options.
  • Select the icon indicated in the next picture.
  • After that, Scroll down to the options.
  • Hence Select the Display Equation on Chart.

Read More: How to Find the Equation of a Line in Excel (With Quick Steps)


Step 3: Show Equation from Format Trendline Command

  • At the last stage, you will find the graph with equations like the one below.

Results to show equation in excel graph

  • Moreover, Change the trendline option from Linear to Exponential.
  • Select the Display Equation on Chart.

Results to show equation in excel graph

  • You can see the result just like the one given below.

Results to show equation in excel graph

  • Again, Select the Logarithmic option and Select the Display Equation on Chart.

Results to show equation in excel graph

  • Hence, you will find the graph just like the one given below.

  • Lastly, Select the Polynomial and Set the Order 3.
  • Select the option Display Equation on chart.

  • As a result, you will find a graph like the one below.

Read More: How to Display Equation of a Line in Excel Graph (2 Easy Ways)


Things to Remember

  • In this example, as my dataset represents a linear equation, the equation found in the chart is linear. However, if your trendline becomes nonlinear, you will find a non-linear equation.

Conclusion

In this article, I have tried to discuss the steps of a method to Show Equation in Excel Graph. I hope this will help to increase your excel skill. Thank you for having faith in us. If you have any queries, feel free to ask in the comment section.


Related Articles

Souptik Roy

Souptik Roy

Hello there. This is Souptik Roy. I graduated from Naval Architecture & Marine Engineering department. I am trying to explore the world of Microsoft Excel and want to increase my analytical power apart from my Engineering degree, as I have a curious mind. this is why I am trying to learn Excel Operations and write articles to help others.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo