title: Excel Chart Several Y values against one X Value
body: <p>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"?</p>