Learn how to add a trendline in Excel, PowerPoint, and Outlook to display visual data trends. Format a trend or moving average line to a chart.

There are different trendline options that are available. You can insert a linear trend line, a polynomial trendline, power trendline, exponential trendline, moving Average trendline.

When you want to add a trendline to a chart in Microsoft Graph, you can choose any of the six different trend/regression types. The type of data you have determines the type of trendline …

Select Chart Design > Add Chart Element. Select Trendline and then select the type of trendline you want, such as Linear, Exponential, Linear Forecast, or Moving Average.

On your chart, click the data series to which you want to add a trendline or moving average. On the Chart Design tab, click Add Chart Element, and point to Trendline.

On the Insert tab, in the Sparklines group, click Line, Column, or Win/Loss. In the Data Range box, enter the range of cells that has the data you want to show in the sparkline.

Use sparklines in Excel to show data trends and visually represent your data within a cell.

Click the data series to which you want to add a trendline or moving average. On the Layout tab, in the Analysis group, click Trendline, and then click the type of regression trendline or moving …

For information about how Microsoft Excel fits a line to data, see LINEST. You can use TREND for polynomial curve fitting by regressing against the same variable raised to different powers. …

To quickly identify a data series in a chart, you can add data labels to the data points of the chart. By default, the data labels are linked to values on the worksheet, and they update …