Show or remove trendlines

Trendlines show you the overall direction (or trend) of your data. Trendlines are mostly used for making financial investment decisions and appear in bar, line, scatter, and bubble charts.

Show trendlines

  1. Click anywhere on the chart to select it.

  2. Click the Series tab at the top of the sidebar on the right.

    If you don’t see the sidebar, or it doesn’t have a Series tab, click Format inspector button in the toolbar.

  3. Click the disclosure triangle next to Trendlines, then click the pop-up menu and choose a type of trendline.

  4. Do either of the following:

    • Show names for the trendlines: Select the Name checkbox, then type a name in the field. The name you type appears for all trendlines on the chart. To change a name, double-click it on the chart, then type a new one.

    • Show the equation or R2 value: Select the Show Equation or R2 Value checkbox.

  5. To change the appearance of a trendline, click the line so you see white dots at either end, and the Trendline tab appears at the top of the sidebar.

    Use the controls in the Stroke and Shadow sections to make changes.

To remove trendlines, click the Trendlines pop-up menu and choose None.

Note:  On iOS devices, trendlines are visible in documents that already have them. You can’t add trendlines in documents you create on an iOS device.