Excel 2010 Scatter Plot Multiple Series. How To Add Multiple Trend Lines In Excel - Graph o. But if you are worried about the spread of data in set 1 and set 2 and difficulty in pattern understanding you can switch x.
Add Trend Lines to Multiple Series. Add 2 additional helper columns to each series. Now the trendline is added to the scatter chart.
Add a 6th series.
Click Scatter with Straight Lines. Tab and Select Data. Here is how you plot a scatter chart with multiple data sets. Scatter Plot Chart With Multiple Series From Selected Range.
