Excel 2016 Scatter Plot Multiple Series. Fi you can see what was done record the same process this time add a second series after the first. To better visualize the relationship between the two variables you can draw a trendline in your Excel scatter graph also called a line of best fit.
Excel will draw a line as close as possible to all data points so that there are as many points. Box and Whisker Plot is an added graph option in Excel 2016 and above. The information in the chart following the illustration can help you make your choices Series option.
Scatter to create a scatter chart.
Add Trend Lines to Multiple Series. In the Format Data Series pane with Series Options selected make the changes that you want. Feb 15 2017 Re. Click the arrow to see the different types of scattering and bubble charts.
