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.

A power trendline is a curved line that is best used with data sets that compare measurements that increase at a specific rate — for example, the acceleration of a race car at one-second …

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.

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.

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.

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.

By default, Excel determines how to display the Sparkline data so with these options you can control the minimum and maximum values. Change the way data is shown. If you click the Edit …

Learn how to create a chart in Excel and add a trendline. Visualize your data with a column, bar, pie, line, or scatter chart (or graph) in Office.

Thanks for using Word. Our community of experts can help with whatever you're looking for. Ask the Word community

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