Chart with two trendlines

Creating a chart with two trendlines have different things in common. But first, you'd need to have data like this:

data table

1. Mark the data (1), click insert (2), and then choose the scatter chart (3), and finally choose a scatter chart without marker (4).

insert scatter chart

2. Right click on any of the series (1), and choose add trendlines (2).

add trendlines

3. Decide the type of trendline you would like.

trendline type

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



Note: Repeat step 2 to four to add the second trendline.

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

ready chart two trendlines