Now we will use the equation to calculate the data points. Therefore, you will get the equation just like the following screenshot inside the graph.Thereafter, choose “ Linear” to draw a linear trendline and checkmark the “ Display Equation on chart” to get the equation.Hence, select any data point from the graph and right right-click the mouse button, and choose “ Add Trendline” to draw the trendline.Secondly, you will get the scatter chart with data points inside the worksheet.First, select numeric data from the list and draw a “ Scatter Chart” from the “ Insert” option.One of the easiest ways to create equation from data points is to draw a trendline and then use it to form the equation. Use Trendline Option to Create Equation from Data Points Now we will make a chart and create equation from data points inside the chart.ġ. Suppose we have a dataset of a manufacturing company’s Total Production and Target Production month-wise. In the following, I have explained 2 simple and quick methods to create equations from data points in Excel. Related Articles How to Create Equation from Data Points in Excel: 2 Quick Methods
