Thread: using two sets of ranges for one series, in scatter plot?

I have two sets of data in two different locations on the worksheet, that need to be 'joined' together in the chart to create a continuous line. How can you insert two sets of ranges in one series for a scatter plot, or manually type in a few numbers and then tack on a range to follow?

Example of how I've tried to do it:

Series X values:
= 0, 1, 2, 'select range from worksheet'

or

Series X values:
= 'select range 1', select range 2'

Excel says in both cases 'the formula contains errors' and will not allow it.
Thanks for any help!

That must be made for both the x and y values at the same time in a single cell? You can't just combine the sets somehow in the Select Data window for the chart, in each separate range selection (x and y)? Thanks.