Change source data of chart by adjusting two cell values

You can not use formula directly in the series data dialog.
You need to define named ranges and then reference the named ranges.

See revised example for xy-scatter