Chart Help - Transactions by Month

[Hydestone]

I am trying to create a chart which would plot a line for each transaction type on the same chart. The Y axis would be quantity of transactions per month. The X axis would be months. Sheet data is attached.

Each month, I'll add more rows of transactions, so the range will need to grab data from the entire columns.

Any suggestions?

MULTI_TRANSACTION6-9-2020-2229.xlsx
	A	B	C	D	E	F	G
1	Confirmation Number	Post Time	Transaction Type	First Name	Last Name	Primary Email	Amount Paid
2	#20200222247511	2/22/2020 12:11	Adult Sailing	first	last	email	275
3	#20200223252890	2/23/2020 11:28	Donations	first	last	email	100
4	#20200227292286	2/27/2020 10:47	Donations	first	last	email	50
5	#20200303358068	3/3/2020 23:07	Donations	first	last	email	50
6	#20200311434134	3/11/2020 11:18	Donations	first	last	email	150
7	#20200312449038	3/12/2020 18:18	Donations	first	last	email	75
8	#20200312450536	3/12/2020 21:50	Donations	first	last	email	50
9	#20200410665979	4/10/2020 19:21	Donations	first	last	email	150
10	#20200504810060	5/4/2020 12:03	Mooring	first	last	email	105
11	#20200511848503	5/11/2020 16:09	Mooring	first	last	email	35
12	#20200512852946	5/12/2020 12:56	Mooring	first	last	email	35
13	#20200514864474	5/14/2020 16:11	Mooring	first	last	email	35
14	#20200517874162	5/17/2020 12:33	Mooring	first	last	email	70
15	#20200517874445	5/17/2020 14:09	Mooring	first	last	email	35
16	#20200526911933	5/26/2020 12:20	Mooring	first	last	email	35
17	#20200529934141	5/29/2020 16:36	Mooring	first	last	email	35
18	#20200530937919	5/30/2020 14:21	Mooring	first	last	email	70
19	#20200602954929	6/2/2020 15:19	Mooring	first	last	email	35
20	#20200603957635	6/3/2020 9:22	Mooring	first	last	email	35
21	#20200603961742	6/3/2020 19:47	Mooring	first	last	email	35
22	#20200603962235	6/3/2020 22:23	Mooring	first	last	email	35
23	#20200604966494	6/4/2020 17:38	Mooring	first	last	email	35
24	#20200606974369	6/6/2020 16:49	Mooring	first	last	email	35
25	#20200607977113	6/7/2020 19:23	Mooring	first	last	email	70
26	#20200130107212	1/30/2020 11:23	Membership Renewal	first	last	email	300
27	#20200229317774	2/29/2020 13:29	Membership Renewal	first	last	email	300
28	#20200303348967	3/3/2020 10:01	Membership Renewal	first	last	email	300
29	#20200305378852	3/5/2020 18:47	Membership Renewal	first	last	email	300
30	#20200307392938	3/7/2020 7:24	Membership Renewal	first	last	email	300
31	#20200307394359	3/7/2020 9:49	Membership Renewal	first	last	email	300
32	#20200312448366	3/12/2020 17:00	Membership Renewal	first	last	email	300
33	#20200314467189	3/14/2020 21:25	Membership Renewal	first	last	email	300
34	#20200330592747	3/30/2020 13:09	Membership Renewal	first	last	email	300
35	#20200415686819	4/15/2020 9:47	Membership Renewal	first	last	email	300
36	#20200505816207	5/5/2020 9:55	Membership Renewal	first	last	email	300
37	#20200514861339	5/14/2020 7:38	Membership Renewal	first	last	email	300
38	#20200514861383	5/14/2020 7:49	Membership Renewal	first	last	email	300
39	#20200514861466	5/14/2020 8:16	Membership Renewal	first	last	email	150
40	#20200514861478	5/14/2020 8:18	Membership Renewal	first	last	email	150
41	#20200517874470	5/17/2020 14:19	Membership Renewal	first	last	email	300
42	#20200518877068	5/18/2020 10:58	Membership Renewal	first	last	email	300
43	#20200518881470	5/18/2020 22:03	Membership Renewal	first	last	email	300
44	#20200520887684	5/20/2020 9:35	Membership Renewal	first	last	email	300
45	#20200607976579	6/7/2020 15:34	Membership Renewal	first	last	email	300
46	#20200304362890	3/4/2020 12:30	New Membership	first	last	email	360
47	#20200308403432	3/8/2020 12:41	New Membership	first	last	email	360
48	#20200309411005	3/9/2020 10:06	New Membership	first	last	email	360
49	#20200309415800	3/9/2020 15:38	New Membership	first	last	email	360
50	#20200314460918	3/14/2020 6:21	New Membership	first	last	email	360
51	#20200515869587	5/15/2020 16:17	New Membership	first	last	email	360
52	#20200516871027	5/16/2020 8:45	New Membership	first	last	email	360
53	#20200526911692	5/26/2020 11:49	New Membership	first	last	email	360
54	#20200527921345	5/27/2020 18:59	New Membership	first	last	email	360
MULTI_TRANSACTION6-9-2020-2229

 

[Toadstool]

Hi Hydestone,

I'd create a summary then just Insert Recommended Chart using I1 to Q6, but you'd need to amend the data range if you add Transaction types or months.

Hydestone.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Confirmation Number	Post Time	Transaction Type	First Name	Last Name	Primary Email	Amount Paid			Jan-20	Feb-20	Mar-20	Apr-20	May-20	Jun-20	Jul-20	Aug-20
2	#20200222247511	2/22/2020 12:11	Adult Sailing	first	last	email	275		Adult Sailing	0	1	0	0	0	0	0	0
3	#20200223252890	2/23/2020 11:28	Donations	first	last	email	100		Donations	0	2	4	1	0	0	0	0
4	#20200227292286	2/27/2020 10:47	Donations	first	last	email	50		Mooring	0	0	0	0	9	7	0	0
5	#20200303358068	3/3/2020 23:07	Donations	first	last	email	50		Membership Renewal	1	1	7	1	9	1	0	0
6	#20200311434134	3/11/2020 11:18	Donations	first	last	email	150		New Membership	0	0	5	0	4	0	0	0
7	#20200312449038	3/12/2020 18:18	Donations	first	last	email	75
8	#20200312450536	3/12/2020 21:50	Donations	first	last	email	50
9	#20200410665979	4/10/2020 19:21	Donations	first	last	email	150
Sheet1

Cell Formulas
Range	Formula
J1	J1	=INT(MIN(B:B))
K1:Q1	K1	=EOMONTH(J1,0)+1
J2:Q6	J2	=COUNTIFS($B:$B,">="&J$1,$B:$B,"<"&EOMONTH(J$1,0)+1,$C:$C,$I2)
I2:I9	I2	=INDEX($C$2:$C$999,MATCH(0,INDEX(COUNTIF($I$1:$I1,$C$2:$C$999),),0))&""