I don't think there is any OOB functionality to achieve this.

There is a work around solution that will require some custom code. You have 2 custom lists  say list  A and List B. Create a temporary list C which would be used for reporting services to plot the charts. When ever there are any data  add/updates on List A or List B you need to sync the data to List C using a event handlers so that you have the latest data in the List C.