You should break column B:B in two columns, by alternate rows, in order
to base a x-y scatter chart on them. Assuming your data start in B1.
Assuming your 2-column breakdown table starts in C2.

In C2:
=OFFSET($B$1, 2*(ROW()-ROW($C$2)), 0)
In D2:
=OFFSET($B$1, 2*(ROW()-ROW($C$2))+1, 0)

HTH
Kostis Vezerides