Divided the calculated value in stacked bar chart

[jozisvk11]

Hello,

I need to make color separation in stacked bar chart.

I have following data:

ID of item        Day capacity      Worked hours         Status

     001                       17                           13                             efective

     002                       17                              7                             non efective

I would like to make stacked bar chart like this:

Explanation: First blue column means Day capacity and second purple color means efective hour and darker purple means non efective hours. 

Thank you for helping me.