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.