I have three columns.
In column A are unique record numbers for individual requests.
In column B are the dates that each request was submitted.
In column C are the dates that each request was executed.
I would like to make a chart that shows the number of records submitted and executed on a weekly basis as two separate bars, then I would like to have a third bar that shows the total number of records that have been submitted either in that week or previously but are still not executed.
I have been trying to set this up in a pivot table with some success but I can't quite figure it out. Honestly I'm not sure if a pivot table is the right way to this.
Using Excel 2016.
Sample data below

