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.
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 |