I am trying to create a scatter plot with multiple series and have them connected.

My data has multiple Y values for a single X value. There are 4 X values and 7 Y values for each X value for a total of 28 Y values.

I've tried every form of Scatter plot (smooth line, straight line, ETC) I have also attempted to set "Show Empty Cells" as "connect data points with line" but no line appears after selecting this.

I have 4 points on my graph, one for each X value. How do I connect these X values with a line?

I've also tried using a trend line, however it asks me to pick a single series for a trend line. I want to use all 4 series in this trend line.

Here is a screenshot of my chart as it is now:

For each X value (300, 600, 900 and 1200) there is a point. How do I connect these points?

Also, I tried doing this with just one series. Entering multiple x values and all y values. This gives me the line I need but the data is WAY off. The highest Y value in the data set is 78 yet the chart only goes up to ~18

Why is this? I know for a fact that the Y values above 18 are in the series data set. I even went and added each cell manually (instead of Shift+Click) to ensure all data points were included. Is it just picking one of the data points and going with it?

I am very confused on how to make a scatter plot connect with multiple sets of data. Ecspecially when those each set only has 1 x value to multiple y values.

isno connecting line. But the legend shows the connecting line extending on either side of the markers. So obviously it's an XY Scatter With Lines chart type. The chart's not showing the user's data as intended, but I suspect it's because the user did not arrange the data in such a way that Excel could guess how the user intended. That's why I regretted not seeing any data. – Jon Peltier Sep 11 '15 at 17:12