Often you may want to add multiple trendlines to a chart in Excel to summarize the trends of multiple series.

For example, you may want to create the following plot with multiple trendlines that summarizes the trend of two different product sales over time:

The following step-by-step example shows how to create this exact plot with multiple trendlines.

Step 1: Create the Data

First, let’s create the following dataset that shows the total sales of two different products during 10 consecutive years:

Step 2: Insert the Scatter Plot

Next, highlight the cell range A1:C11, then click the Insert tab along the top ribbon, then click the Scatter icon within the Charts group:

The following scatter plot will automatically appear:

The blue dots represent the sales each year for Product A and the orange dots represent the sales for Product B each year.

Step 3: Add the Trendlines

Next, click on any of the blue dots in the plot.

Then click the tiny green plus sign that appears in the top right corner of the chart, then click the dropdown arrow next to Trendline, then click More Options:

Repeat this same process for the orange dots.

Two trendlines with their equations will now be displayed on the chart:

Step 4: Customize the Chart Appearance

Lastly, click on the individual labels in the legend called Linear (Product A) and Linear (Product B) and delete them.

Then add a custom chart title, add custom axis labels, and make the font color of the trendline equations bold to make them easier to read.

The final chart will look like this:

The following tutorials explain how to perform other common tasks in Excel: