Excel Chart Several Y values against one X Value


I have a multiple columns representing Y values each against a specific x value. I am doing a scatter plot. When plotting each series, I can easily select the y values as they are present in columns but the x value is constant for each column and I cant seem to figure out how to repeat a constant x value against several y column values.
Does someone know how to provide a single repeatable value in the text box "X-Values"?

Best Solution

Arrange your data like this, then select the range of cells containing ALL the Y-values, and from the ribbon, do Insert Chart | Scatterplot.

Is this what you expect? Each Series in this chart represents one Column of data. The X-Values are not repeated, nor do they need to be repeated.

enter image description here

You may need to slightly adjust the range for the values, you can do this by "grabbing" the blue/purple outline of the range, and resizing it , like:

enter image description here

If you don't like the default/numeric X-axis labels, then create the chart as a Line chart, initially, and then format the series so that there is "No Line", the result should look like a scatterplot, except it will use the Category Labels:

enter image description here

Related Question