Stacked column based on historic data

Hi, 

I have the following chart built: 

I would however like to add stacked columns within it, where each layer in the stacked column should correspond with the status of the ID (i.e., 0-Not Started, 1-Deliverable Defined, 2-Draft, 3-Draft in Review, 4-Approved) for any given date. 

In other words, an ID may have the status 0-Not Started on October 11, but this might change to 4-Approved on October 12 (I am importing data from SharePoint). Hence, the stacked columns should correspond to what was the status distribution per date, and prefferably only show columns up until TODAY. 

I have the following table: 

Have any of you touched upon this, or have any tips on how I could proceed?