Trendlinie Excel. This analytical tool is most often used to show data movements over a period of time or correlation between two variables. If you don t see the icon click the chart.
Click the trendline tickbox. Linear it is a straight line that shows the increase decrease in the value of data over time at a steady rate. Select the whole data including column headings.
Choose a trend regression type.
Excel displays the trendline option only if you select a chart that has more than one data. Here are the quick steps to add a trendline. You can also extend trendlines to forecast future data. Type 3 in the forward box.
