Excel 2016 Scatter Plot Multiple Series. As new series with x values. Select Format Data Series.
Select the sets of experiment data and click Insert. The line chart axis gave you the nice axis and the XY data provided multiple time series without any gyrations. IF You have your data layed out as suggested record a macro of you making the first graph with the first series.
Click on the Insert tab.
Scatter plot with multiple series from 1 table 1 Select the column chart data and create the column chart. However previous versions of Excel do not have it built-in. Learn how to create a scatter plot using Excel 2016. 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.
