We can **add an equation to a graph in excel** by using the **excel equation of a line**. Graph equations in excel are easy to plot and this tutorial will walk all levels of excel users through the process of showing **line equation and adding it to a graph**.

*Figure 1: Graph equation*

**Tabulate Data**

- We will tabulate our data in two columns.

* Figure 2: Table of Data*

- We will then highlight our entire table and click on
**“insert**”, then we will then select the**“scatter chart”**icon to display a graph

* Figure 3 – Scatter chart*

* Figure 4: Graphical Representation of Data*

- We will now click on the
**“+”**icon beside the chart to edit our graph by including the Chart Title and Axes. We will also remove the gridlines.

* Figure 5: Edited Graph Parameters*

- We will now
**add the equation of the chart**by right clicking on any of the point on the chart, select**“add trendline”**, then scroll down and finally select**“Display Equation on Chart”**.

* Figure 6: Equation of a line*

**Instant Connection to an Expert through our Excelchat Service**

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

## Leave a Comment