Excel Graph help

[Pington10]

Hi, I would like to ask for help in creating a graph for my monthly report as per illustrated in the picture below. It's a fairly simple chart. If there are better option for graphs, i can adopt it as well.

[#2 · Accepted solution]

@Pington10 

You need to lay out the data slightly differently. You can then create a stacked column chart.

Sample workbook attached.

[#3]

Thanks a lot for the demo @HansVogelaar, really appreciate it