Yes, you should use a scatter chart.
You need one dot per data point/record so you should use the record id as dimension. If you don't have a record id, you should create one in the script:
recno() as RecordID,
In the scatter plot, you should switch to "Advanced mode" and use the following two expressions: