Using text as data?

[Maza128]

I am attempting to use text based results as data to produce a chart, e.g.

Out of this I would like to create a stacked bar chart with date on the x-axis and the no. of project sub-types on the y-axis. However having significant trouble doing this. Any suggestions?

Thanks!