In the ‘Label’ dropdown, click on ‘Use Equation’. To add the trendline equation to your scatter plot, navigate to Chart Editor > Customize > Series > Label. Trendline Visualĭepending on your data points, Google Sheets will display a line (trendline) with the shortest distance between your data points and the line itself.

In the ‘Series’ section under the trendline checkbox, you have options to customize your trendline - line thickness, color, opacity, and more. Navigate to Chart Editor > Customize > Series, then check the trendline box to add a trendline to your chart. To add trendline equations to your chart, you must first have a chart with trendlines. How To Add Equation To Graph In Google Sheets? Let’s look at how to add this equation to your chart. Using this equation, you can identify whether or not a trend is present in your data points. Where x is the independent variable, y is the dependent variable, m is the slope of the line, and b is the y-intercept. The equation of a linear relationship is y = mx + b. The trendline equation is used to define this line. Depending on the nature of a scatter plot, this line should have the shortest distance between each data point and the line itself. The linear trendline equation is a linear relationship that describes the line that best fits a set of numerical data points. However, this article focuses on the linear trendline. There are different types of trendlines depending on the chart type and purpose of the trendline. How to Use Excel to Graph an Equation or Function.How To Add Equation To Graph In Google Sheets?.

Export trendline equation in excel