Charting Multiple Criteria

[DShack]

Hello All,
I am trying to chart an array of data that consists of Date, Total Time Taken and number of invoices however i can not seem to get the chart to display in a way that makes sense. I have three sets of data for each process that data is consumed labeled by the headers in the preview data below. Any suggestions or help would be greatly appreciated.

Inbound PROD Stats.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1	PTDE				VPT				RPTL
2	Day	Sum of Time Taken	Sum of Invoices		Day	Sum of Time Taken	Sum of Invoices		Day	Sum of Time Taken	Sum of Invoices
3	9/15/2021	0:02:37	773		9/15/2021	0:03:30	773		9/15/2021	0:01:08	773
4	9/16/2021	0:03:43	2041		9/16/2021	0:12:50	2041		9/16/2021	0:03:25	2040
5	9/17/2021	0:03:06	3658		9/17/2021	0:13:02	3658		9/17/2021	0:02:39	3657
6	9/18/2021	0:02:59	3295		9/18/2021	0:11:35	3295		9/18/2021	0:01:17	3295
7	9/19/2021	0:02:43	3295		9/19/2021	0:07:31	3295		9/19/2021	0:01:19	3295
8	9/20/2021	0:03:17	4753		9/20/2021	0:23:37	4753		9/20/2021	0:04:04	7082
9	9/21/2021	0:04:40	9380		9/21/2021	0:37:22	9380		9/21/2021	0:07:36	9381
10	9/22/2021	0:05:37	18161		9/22/2021	0:59:03	18161		9/22/2021	0:06:10	18160
11	9/23/2021	0:04:41	7825		9/23/2021	0:28:48	7825		9/23/2021	0:25:06	7825
12	9/24/2021	0:05:20	8017		9/24/2021	0:41:27	8017		9/24/2021	0:11:27	12845
13	9/25/2021	0:03:20	297		9/25/2021	0:01:49	297		9/25/2021	0:00:57	297
14	9/26/2021	0:03:19	300		9/26/2021	0:01:31	300		9/26/2021	0:02:10	300
15	9/27/2021	0:05:14	4117		9/27/2021	0:42:55	4117		9/27/2021	0:03:48	4117
16	9/28/2021	0:02:51	3851		9/28/2021	0:18:34	3851		9/28/2021	0:05:02	3851
17	9/29/2021	0:07:44	3951		9/29/2021	0:15:26	3951		9/29/2021	0:03:33	3951
18	9/30/2021	0:06:53	6758		9/30/2021	0:26:23	6758		9/30/2021	0:05:53	6758
19	10/1/2021	0:07:57	2031		10/1/2021	0:39:03	2031		10/1/2021	0:10:15	2031
20	10/2/2021	0:04:25	281		10/2/2021	0:03:54	281		10/2/2021	0:01:23	281
21	10/3/2021	0:03:56	262		10/3/2021	0:01:03	262		10/3/2021	0:01:10	262
22	10/4/2021	0:07:28	7703		10/4/2021	0:33:10	7703		10/4/2021	0:12:37	7703
23	10/5/2021	0:10:33	8986		10/5/2021	1:03:34	8986		10/5/2021	0:12:43	8986
24	10/6/2021	0:09:22	17073		10/6/2021	2:22:56	17073		10/6/2021	0:09:21	17073
25	10/7/2021	0:01:28	1204		10/7/2021	0:04:58	1204		10/7/2021	0:00:56	1204
Sheet6

 

[ravi2628]

hi

are you looking for a chart like this.

View attachment 48632

 

[DShack]

hi

are you looking for a chart like this.

View attachment 48632

I tried looking at the image but it was not able to display image.

 

[ravi2628]

I tried looking at the image but it was not able to display image.

hi

I don't know what is the exact issue is so I am again uploading the image for you.

Book1
	M	N	O	P	Q
1	Graph Table				VPT
2	Day	Sum of Time Taken	Sum of Invoices
3	9/30/2021	00:26:23	6758
4	9/29/2021	00:15:26	3951
5	9/28/2021	00:18:34	3851
6	9/27/2021	00:42:55	4117
7	9/26/2021	00:01:31	300
8	9/25/2021	00:01:49	297
9	9/24/2021	00:41:27	8017
10	9/23/2021	00:28:48	7825
11	9/22/2021	00:59:03	18161
12	9/21/2021	00:37:22	9380
13	9/20/2021	00:23:37	4753
14	9/19/2021	00:07:31	3295
15	9/18/2021	00:11:35	3295
16	9/17/2021	00:13:02	3658
17	9/16/2021	00:12:50	2041
18	9/15/2021	00:03:30	773
Sheet1

Cell Formulas
Range	Formula
M3	M3	=SORT(IFERROR(LOOKUP(2, 1/(COUNTIF($M$2:M2,$A$3:$A$18)=0), $A$3:$A$18), LOOKUP(2, 1/(COUNTIF($M$2:M2, $E$3:$E$18)=0), $E$3:$E$18)))
N3:N18	N3	=IF($Q$1="PTDE",SUMIFS($B$3:$B$18,$A$3:$A$18,$M3),IF($Q$1="VPT",SUMIFS($F$3:$F$18,$E$3:$E$18,$M3)))
O3:O18	O3	=IF($Q$1="PTDE",SUMIFS($C$3:$C$18,$A$3:$A$18,$M3),IF($Q$1="VPT",SUMIFS($G$3:$G$18,$E$3:$E$18,$M3)))
M4:M18	M4	=IFERROR(LOOKUP(2, 1/(COUNTIF($M$2:M3,$A$3:$A$18)=0), $A$3:$A$18), LOOKUP(2, 1/(COUNTIF($M$2:M3, $E$3:$E$18)=0), $E$3:$E$18))
Press CTRL+SHIFT+ENTER to enter array formulas.

Cells with Data Validation
Cell	Allow	Criteria
Q1	List	PTDE,VPT,RPTL