Looking for idea

Hello Champs, 

Need a help to create a dynamic chart data. I have 3 data table, eg, 1st table contains all the open issues raised 2nd table contains issues raised one that particular day and the 3rd table contain issue closed that particular day(it may be raised a week ago also).  

I want to create a common data field as a date and count of open issues / Created issues  / Closed issues in a single chart. 

Could you please me, i have attached my requirement based on excel chart.