How to Add Multiple Trendlines in Excel

Creating a chart with two trendlines has different things in common.

But first, you’d need to have data like this:

Chart with two trendlines data table

Inserting a chart

Mark the data, click insert, and then choose the scatter chart, and finally choose a scatter chart without marker.

insert scatter chart

Adding a trendline

Right-click on any of the series, and choose add trendline.

Chart with two trendlines add trendlines

Decide the type of trendline you would like to see.

Chart with two trendlines trendline type

Scroll down, and choose if you would like to display anything like an equation or R-squared value.

Chart with two trendlines equation

Note: Repeat steps 2 through 4 to add the second trendline.

By following these steps, you will have a result that is very similar to this:

ready chart two trendlines

A second trendline has been added to the chart.

How to add a trendline for the same dataset

You can add as many trendlines as you like. As you can see in the picture above, I have added two trendlines: one for Mark and one for John.

Excel offers me the ability to add multiple trendlines for the same data series. I can have a lot of trend lines for Mark and a lot for John.

The process for adding a trendline to the same dataset is the same.

Click on your chart.

A plus sign will appear in the top right corner. Click on it. The Chart elements menu will open.

At the bottom of the menu is a Trendline option. It’s checked because you already have trendlines added to your chart. Click the right arrow.

Adding another trend line for data series

Select the type of trendline you want to add. In case you want to have more options or to format the trendline right away, click More Options.

See also  How to create a Sunburst Chart in Excel

Excel will ask you for which data series you want to add another trendline. Decide and click ok.

adding multiple trend line for data series

This way you can add some trend lines to your chart.

chart with too many trend lines

Be careful not to add too many trend lines as the visibility of the chart will be poor.