How to display trend lines in a chart

In this lesson you will learn how to display a trend line on a chart and control various settings on it.

Prerequisites

To use the trend line functionality, your layout must be displaying an X/Y chart.

Add trend lines

Right click in the pivot view and choose to "Show trend lines"

Change trend line options

The trend line options available allow you to change the type of line generated and also change how many lines are created. These are the settings for the example below.