Column chart to compare different periods

Good evening everybody,

I am not good at Excel and I am having problems to plot a column chart so it shows Q1, Q2, Q3 and Q4 in the horizontal axis and the number of cash deposits and the values of such deposits in the vertical one.
I will like to plot the one I have on tab "dashboard" where you can put Q2 and Q1 together. When I click on select data and try to put the cell D8 from the cash deposit data Q1 and the same cell but from cash deposit data Q2 it does not allow me to do so.

Can you kindly help?

Thank you
Viewotst

Agreed, much better your way. Just some questions:

What do you mean with "I made the values static rather than random so you can get the results"?
Is there any way that the pivot and the graph get updated if I add more data to the list on the left-hand side or would I have to manually modify the pivot data source to include the new lines in the list and then refresh it and also the graph?

Last question is about graphs, if you see the image attached, how could I modify the "Horizontal (category) Axis Labels? Letīs say I just want two tick boxes for Q1 and Q2 rather than five of them. There is not remove button option for the Horizontal, only for the legend entries.

Thanks a lotAttachment 763699

Thank you for your quick response and help.

I have re-attached the image.

Thank you
Viewotst