Within the Charts group click on the plot option called Scatter with Smooth Lines and Markers. In line charts column and bar graphs numeric values are plotted only on the y-axis. Excel multiplies the last two numbers and adds the first number to the result.
To add the r square value to the graph click the Display R-squared value on chart check box.
Under the Chart Design tab select Add Chart Element. In Excel while working non-linear trend lines set of points on an exponential excel functions graph or non-linear graphs the EXP function in Excel is widely used. To graph a linear equation all you have to do it substitute in the variables in this formula. Excel trendline equation is correct only in scatter charts.