Required Visual Suggestion

Please check your question.

It does not make sense.

You say 

1. A Clustered BAR representing the total capacity of the User across all projects.
2. A Stacked BAR representing the sum of completed work, segmented by individual Projects.

but them provide a output example by  Project and User.

Try provide consistent input data, desired output and step by step description.

You will get a quick response if you put time, care and effort into writing clear problem descriptions.

Thanks