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 …

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.

If you click the Date Axis Type option in this drop-down, Excel opens the Sparkline Date Range dialog box. From here, you can select the range in your workbook that contains the date …

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 add a new legend entry, type the reference to the worksheet cell or type a new name and then, in the Series values box, type a reference to the data series on the worksheet that you want to …

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.

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

Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter.