Grouping rows of data for a chart

[marcidee]

Please can someone help me with a chart I am trying to put together.

I have data per month for 12 months - 3 departments - I want two columns per month - one columns showing cash in for the 3 departments and next to it a column for the 3 departments showing cash out.

So each month there are 2 columns which would have 3 colours for cash in and next to it a column 3 colours for cash out - I can only seem to achieve one column with all the data in.

So somehow I need to group all the 'cash in' figures to produce one column and then group all the 'cash out' figures and have them side by side.

I have attached an example of what I am trying to achieve except it would have 3 lots of data in each column

Thank you for your help

 

[Sergius]

Why don't you provide a piece of data based on which we can do something? It is not clear from the picture what and how.

 

[marcidee]

Book10
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Date	Oct 2023	Nov 2023	Dec 2023	Jan 2024	Feb 2024	Mar 2024	Apr 2024	May 2024	Jun 2024	Jul 2024	Aug 2024	Sept 2024
2	Studio B Production Cash In	1,200.00	134.23	18,201.60	1,500.00	896.64	12,007.09	116,800.49	21,513.97	46,967.22	34,702.94	73,773.24	132,401.65
3	Studio B Branded Cash in	21,777.23	62,713.53	81,435.86	272,081.19	149,378.17	48,052.20	147,745.00	155,502.59	130,467.37	59,113.10	167,015.44	131,532.45
4	Misc Cash in	211,285.44	131,137.26	194,249.31	264,774.50	161,416.55	148,778.26	108,227.35	289,142.38	204,280.83	144,441.61	233,922.11	137,640.60
5
6	Studio B Production Cash out	1,009.29	3,800.49	1,994.80	107.4	678.68	2,339.81	17,678.36	7,788.85	20,377.64	35,600.53	27,470.88	27,394.70
7	Studio B Branded Cash out	20,032.84	18,140.72	40,820.83	37,497.67	19,304.35	27,576.51	16,499.24	29,393.60	21,875.60	30,884.00	54,173.59	23,707.54
8	Misc Cash out	223,320.45	172,035.61	362,270.32	338,793.19	310,821.12	237,925.21	202,298.29	409,496.24	261,830.87	259,412.95	387,304.22	252,518.01
9
Sheet1

Why don't you provide a piece of data based on which we can do something? It is not clear from the picture what and how.

So I am looking for 2 columns for each month - one showing cash in and the other showing cash out - each column would show the 3 lines (Studio B production, Studio n Branded, Misc)