Add a trendline or other line to a chart

You can add a trendline 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. However, a trendline cannot be added to a data series in any chart type that is stacked or 3-D. Trendlines are also not available for radar, pie, surface, or doughnut charts.

Note: This article describes procedures for the Mac. If you are using a PC running Windows, see Add, change, or remove a trendline in a chart.

  1. On the View menu, click Print Layout.

  2. In the chart, select the data series that you want to add a trendline to, and then click the Chart Design tab. 

    For example, in a line chart, click one of the lines in the chart, and all the data marker of that data series become selected.

    Chart Design tab

  3. On the Chart Design tab, click Add Chart Element, and then click Trendline.

    Add a trendline

  4. Choose a trendline option or click More Trendline Options.

    Trendline options

    You can choose from the following:

    • Exponential

    • Linear

    • Logarithmic

    • Polynomial

    • Power

    • Moving average

    You can also give your trendline a name and choose forecasting options.

  1. On the View menu, click Print Layout.

  2. Click the chart with the trendline, and then click the Chart Design tab.

    Chart Design tab

  3. Click Add Chart Element, click Trendline, and then click None.

    Remove trandline

    You can also click the trendline and press DELETE .

  1. On the View menu, click Print Layout.

  2. In the chart, select the data series that you want to add a line to, and then click the Chart Design tab. 

    Chart Design tab

    For example, in a line chart, click one of the lines in the chart, and all the data marker of that data series become selected.

  3. Click Add Chart Element, and then click Gridlines.

    Add Chart Element menu

  4. Choose the line option that you want or click More Gridline Options.

    Add gridlines

    Depending on the chart type, some options may not be available.

  1. On the View menu, click Print Layout.

  2. Click the chart with the lines, and then click the Chart Design tab.

    Chart Design tab

  3. Click Add Chart Element, click Gridlines, and then click More Gridline Options.

    Add gridlines

  4. Select No line.

    Remove gridlines

    You can also click the line and press DELETE .

Word

  1. On the View menu, click Print Layout.

  2. 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 marker of that data series become selected.

  3. Under Analysis, click Trendline, and then click the trendline that you want.

    Chart Layout tab, Analysis group

    If you see the Add Trendline dialog box, select the series that you want to add the trendline to.

    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.

  1. On the View menu, click Print Layout.

  2. Click the chart with the trendline, and then click the Chart Layout tab.

  3. Under Analysis, click Trendline, and then click No Trendline.

    Chart Layout tab, Analysis group

    You can also click the trendline and press DELETE .

  1. On the View menu, click Print Layout.

  2. 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 marker of that data series become selected.

  3. Under Analysis, click Lines, and then click the line that you want.

    Chart Layout tab, Analysis group

    Depending on the chart type, some options may not be available.

  1. On the View menu, click Print Layout.

  2. Click the chart with the lines, and then click the Chart Layout tab.

  3. Under Analysis, click Lines, and then click No Lines.

    Chart Layout tab, Analysis group

    You can also click the line and press DELETE .

PowerPoint

  1. 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 marker of that data series become selected.

  2. Under Analysis, click Trendline, and then click the trendline that you want.

    Chart Layout tab, Analysis group

    If you see the Add Trendline dialog box, select the series that you want to add the trendline to.

    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.

  1. Click the chart with the trendline, and then click the Chart Layout tab.

  2. Under Analysis, click Trendline, and then click No Trendline.

    Chart Layout tab, Analysis group

    You can also click the trendline and press DELETE .

  1. 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 marker of that data series become selected.

  2. Under Analysis, click Lines, and then click the line that you want.

    Chart Layout tab, Analysis group

    Depending on the chart type, some options may not be available.

  1. Click the chart with the lines, and then click the Chart Layout tab.

  2. Under Analysis, click Lines, and then click No Lines.

    Chart Layout tab, Analysis group

    You can also click the line and press DELETE .

Excel

  1. 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 marker of that data series become selected.

  2. Under Analysis, click Trendline, and then click the trendline that you want.

    Chart Layout tab, Analysis group

    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.

  1. Click the chart with the trendline, and then click the Chart Layout tab.

  2. Under Analysis, click Trendline, and then click No Trendline.

    Chart Layout tab, Analysis group

    You can also click the trendline and press DELETE .

  1. 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 marker of that data series become selected.

  2. Under Analysis, click Lines, and then click the line that you want.

    Chart Layout tab, Analysis group

    Depending on the chart type, some options may not be available.

  1. Click the chart with the lines, and then click the Chart Layout tab.

  2. Under Analysis, click Lines, and then click No Lines.

    Chart Layout tab, Analysis group

    You can also click the line and press DELETE .

See also

Edit data in a chart

Change a chart

Animate text, objects, and charts in PowerPoint for Mac

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×