Can I plot several scatter plots on the same chart?
So col A would be x axis data set for plot 1
col B would be y axis data set for plot 1
col C would be x axis data set for plot 2
col D would be y axis data set for plot 2
etc
Thanks
Yes, it is possible, in 2019.
Highlight all your data and create a scatter plot. Col A will be the x axis, col B will give you one of the desired plots, col C and D will give you garbage (temporarily). Right click on the chart to edit it and select Data Ranges. On the left select “Column D”, then select “X-values” on the right. In the box titled “Range for X-Values” change the As to Cs to use the C column for the X values associated with D. Now go back to the left side and select “Column C”, then click remove. This keep it from trying to plot Column C as Y data. This should give you the plot described in your question.
1 Like
NO. You can only have ONE x-axis per chart.
If you can consolidate the x-axises in one col, you can use different columns for y1, y2… with there related x-values and plot 1, 2 graphs in one chart.