Trendlinie In Excel. Click the button on the right side of the chart click the arrow next to trendline and then click more options. Choose a trend regression type.
R squared valuemeasures the trendline reliability the nearer r2 is to 1 the better the trendline fits the data. Excel displays the trendline option only if you select a chart that has more than one data. Ensure linear is selected and close.
Select the whole data including column headings.
Ensure linear is selected and close. Right click on the line of your line chart and select add trendline. Select the whole data including column headings. Trendline equationis a formula that finds a line that best fits the data points.
