[middy]

Assuming you have selected the correct chart type in Step 1 of the Chart Wizard i.e. XY (scatter).

In Step 2 click on the 'Series' tab at the top of the window and from there you can select the X and Y data to use yourself.