For chart, I think you need create an additional dataset by using unpivot function in your SQL query and the dataset output should look like this:
Client Name Month Values
Client 1 March 2008 200
Client 1 April 2008 100
Anyway, if you have any problem with unpivot function, please let me know and past your orginal SQL query.