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?
2 Replies
All depends on goals. In general you may plot two scatter series based on two columns, but X-axis with that will be sequential integer numbers. Other word points numbers.
For that select default series was added automatically, edit it and delete X range
Next manually add another series but for another column
to have
Next, adjust cosmetics.
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.
