I've got a spreadsheet that has several columns that hold the same type of data (a list of average measurements). They're separated into different columns as each on represents a slightly different measurement.
I have a need to plot a scatter graph of the data in several of these columns as if they were concatenated into one single column and were one range. Simply CTRL+clicking multiple columns seems to create three ranges separated by commas and doesn't give the expected result on the graph (it seems to treat them as three distinct sets of data rather than combining them into one).
Here's an example of what I mean. The graph on the top right was created simply by setting the series name, leaving the series X-values blank and then selecting a single column for the series y-values. This creates that scatter graph I expect.
I then try to do the same thing for the graph in the bottom right, except I CTRL+click three columns for the series y-values. Unfortunately, it looks completely different (I don't really understand how it's representing the data and where it's getting those x-values from).
Is it possible to have multiple ranges treated as a single continuous range in formulae?