Stacked Column to track task completion dates with conditions

See what you can do with the attached. I've used Countifs() to sum up the data in a table on Sheet2. Now you can graph off that. One suggestion included, but you can do a stacked column if you prefer.

Ultimately, a pivot table to sum up your data might also be an option.

Let me know if this works for you