SOLVED

Excel Graph help

Copper Contributor

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.

SimpleGraph.jpg

2 Replies
best response confirmed by Pington10 (Copper Contributor)
Solution

@Pington10 

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

 

HansVogelaar_0-1715340192560.png

Sample workbook attached.

Thanks a lot for the demo @Hans Vogelaar, really appreciate it :cool:

1 best response

Accepted Solutions
best response confirmed by Pington10 (Copper Contributor)
Solution

@Pington10 

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

 

HansVogelaar_0-1715340192560.png

Sample workbook attached.

View solution in original post