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 |
-
On the View menu, click Print Layout.
-
In the chart, select the data series that you want to add a trendline to, and then click the Chart Layout tab.
For example, in a line chart, click one of the lines in the chart, and all the
data markers A bar, area, dot, slice, or other symbol in a chart that represents a single data point or value that originates from a cell on a sheet. Data markers of the same color constitute a data series.
of that
data seriesA group of related data points plotted in a chart that originate from rows or columns on a single sheet. Each data series in a chart has a unique color or pattern. You can plot one or more data series in a chart. Pie charts have only one data series.
become selected.
-
Under Analysis, click Trendline, and then click the trendline that you want.

If you see the Add Trendline dialog box, select the series that you want to add the trendline to.
 | Tip To customize a trendline name or add an equation label, under Analysis, click Trendline, and then click Trendline Options. In the navigation pane, click Options, and then make the changes that you want. |
 | Remove a trendline |
-
On the View menu, click Print Layout.
-
Click the chart with the trendline, and then click the Chart Layout tab.
-
Under Analysis, click Trendline, and then click No Trendline.

 | Tip You can also click the trendline and press
DELETE. |
 | Add other lines |
-
On the View menu, click Print Layout.
-
In the chart, select the data series that you want to add a line to, and then click the Chart Layout tab.
For example, in a line chart, click one of the lines in the chart, and all the
data markers A bar, area, dot, slice, or other symbol in a chart that represents a single data point or value that originates from a cell on a sheet. Data markers of the same color constitute a data series.
of that
data seriesA group of related data points plotted in a chart that originate from rows or columns on a single sheet. Each data series in a chart has a unique color or pattern. You can plot one or more data series in a chart. Pie charts have only one data series.
become selected.
-
Under Analysis, click Lines, and then click the line that you want.

Depending on the chart type, some options may not be available.
 | Remove other lines |
-
On the View menu, click Print Layout.
-
Click the chart with the lines, and then click the Chart Layout tab.
-
Under Analysis, click Lines, and then click No Lines.

 | Tip You can also click the line and press
DELETE. |