I am trying to do exactly what the answer to this other question explains (I have several sets of data to be plotted in one graph with the same x-and y-axis); but with one difference:
- I don't have simply one column with the x-values; I have the x- and y-values of different sets in pairs of columns by themselves. See the picture:
I want to plot all sets in one plot window in different colors. The problem is that if I choose the x-values (in column B) and y-values (in column C) for #2i in the picture, then I cannot also choose the x-values and y-values of the others #2o and #3i, etc. I can only choose the y-value for those, which means that their y-values are plotted to the #2i x-values - which of course is wrong.
If I do try to mark the x-value column ranges also, these just show up as yet another data set in the graph (as y-values).
As you can see in the plot below, all points have the exact same x-value and are placed exactly above each other (while their y-values are correct):
I choose the ranges as shown here:
where you can see that I have chosen the x-values in column B over the whole range (which does not work), since I cannot find out how to choose each set of x-values to match the respective y-values in column C.
How can I solve this?