Add a trendline or other line to a chart

You can add a trendlineA graphical representation of the trend, or direction, of data in a series. Trendlines are used for the study of problems of prediction, also called regression analysis. You can add trendlines to data series in unstacked 2-D area, bar, column, line, stock, xy (scatter), and bubble charts. or other line to any data series in an area, bar, column, line, stock, xy (scatter), or bubble chart that is 2-D and not stacked.

Note  A trendline cannot be added to data series in any chart type that is stacked or 3-D. Trendlines are also not available for radar, pie, surface, or doughnut charts.

Do any of the following:

Add a trendline

Remove a trendline

Add other lines

Remove other lines