Excel Chart Several Y values against one X Value

Question

Hi,

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"?

Answer 1

If I understood your question correctly, you probably should reshape your data to a single series, so that you have 2 columns and many rows. Column A keeps x values, column B the corresponding y values.

So, from this:

   A  B  C  D ...
1  10 13 16 17
2  11 14    18
3  12

to this:

   A  B  C  D ...
1  xa 10
2  xa 11
3  xa 12
4  xb 13
5  xb 14
6  xc 16
7  xd 17
8  xd 18

Answer 2

I've no idea if you still need to find out how to do this, but I had the same problem and the 1st answer here inspired me to try something... and it worked. Basically you just repeat the x value n times for the corresponding y values in a separate column. Say your x values are 2.5, 5, 7.5, and 10, and your y values are 1,2,3,4,5,6,7,8 (2 y's for each x), in column A you would put 2.5, 2.5, 5, 5, 7.5, 7.5, 10, 10, and in column B you would put 1,2,3,4,5,6,7,8. Hope this helps.