Easy Excel Question - Scatter plots

[gtrinh]

Hello
I have a scatterplot for 4 different data series and I would like to see what the trend for all 4 of them would be (similar to image shown). How do I do that?

I tried adding a trendline, but excel will only do it for each individual trendline. I would like to see as a whole, what the trend for all 4 dataseries would look like.

Please advise,
Thank you
Gerald

 

[Oaktree]

One way is to add a 5th series that consists of all of the data points from all 4 of your other series. Add a trendline to that new series and format it so the markers are "none" and thus invisible.

 

[gtrinh]

Brilliant! I'll give that a try. Thank you

Gerald