You will not be able to use an existing recordset to get the data, but you can use the SQL query from that recordset to populate your data.
First you will have to create the chart using dynamic data with fake dynamic values.
You can then go into your DynamicWebCharts->Data directory in your site and open the untitled_data[num].php file that corresponds with your chart.
In this file you can find the line where this variable is set as the query:
You can then set the SQL statement you have setup for the recordset into this variable making sure you specify a value for XLABEL and YVALUE to be selected from that query.