I am trying to plot different types of data onto one graph, my data is as follows:
Ideally, the x axis should have the month labels, the incoming money should be one line with the y axis on the left and the outgoing money another line in a different colour with the y axis on the right side of the graph. Is this possible to do using excel or do I need to look at an alternative solution?
| Mar-21 | April 2021 | |||
| Incoming Money | Outgoing Money | Incoming Money | Outgoing Money | |
| Marketing | 200.00 | 100.00 | 300.00 | 100.00 |
| Shop | 400.00 | 500.00 | 700.00 | 500.00 |
Ideally, the x axis should have the month labels, the incoming money should be one line with the y axis on the left and the outgoing money another line in a different colour with the y axis on the right side of the graph. Is this possible to do using excel or do I need to look at an alternative solution?
