Forum Discussion
texadave
Mar 06, 2020Copper Contributor
Inserting 2 trendlines on one chart
I have 2 sets of data, each consisting of two variables and a bunch of values under each variable (picture attached below). How can I insert two trend lines on the same chart [scatter plot] so t...
- Mar 08, 2020
Kickepe
Feb 07, 2023Copper Contributor
I am trying to do the same thing as above. How do I do it in excel 365. Please Help.
Riny_van_Eekelen
Feb 08, 2023Platinum Contributor
Kickepe Didn't actually remember what the issue was her, but the I first selected one data set (i.e. A2:B5), created a scatter plot of that. Then you go to Select Data on the Chart Design ribbon and add the second series with the proper ranges (C2:C5 and D2:D5). Finally, add a trend line for each series.
All was done in MS365. There's nothing really special about it in 365.