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 table1. 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 chart2. Right click on any of the series (1), and choose add trendline (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

Second trendline has been added to the chart.


You can download the Template here – Download