create graph from daily data of dataset

I have below two table form Azure and would like to plot two graph.

Graph 1 = Y-axis : No. of work items in close state from the items present at start of sprint date / total no of work items present at start of sprint date.  X-axis : Sprint name

Graph 2 = Y-axis :  No. of work items added after sprint start date /  total no of work items present at start of sprint date. X-axis : Sprint name

Table 1 consists of work item data status for every day.

Table 2 consists of sprint name , start date and end date.  

Table 1: 

Table 2: below is sample data, it as different teams, differt sprint and lot of workitem