Forum Discussion
Cannot Create a Scatter Plot with Two Variables
I have two columns with the same amount of data points. But when I select them to create a scatter plot, the chart will only show 1 series. I need two. How do I fix this?
I think you want a line chart (you can choose to not show the line and only the data points). Then each column will be plotted as its own series.
A scatter plot is Y plotted against X so excel is using 1 of the columns for the x-axis and the other is on the y-axis and hence 1 series.