Charting Multiple Criteria

DShack

Board Regular
Joined
Jan 15, 2014
Messages
59
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
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
ABCDEFGHIJK
1PTDEVPTRPTL
2DaySum of Time TakenSum of Invoices DaySum of Time TakenSum of Invoices DaySum of Time TakenSum of Invoices
39/15/20210:02:377739/15/20210:03:307739/15/20210:01:08773
49/16/20210:03:4320419/16/20210:12:5020419/16/20210:03:252040
59/17/20210:03:0636589/17/20210:13:0236589/17/20210:02:393657
69/18/20210:02:5932959/18/20210:11:3532959/18/20210:01:173295
79/19/20210:02:4332959/19/20210:07:3132959/19/20210:01:193295
89/20/20210:03:1747539/20/20210:23:3747539/20/20210:04:047082
99/21/20210:04:4093809/21/20210:37:2293809/21/20210:07:369381
109/22/20210:05:37181619/22/20210:59:03181619/22/20210:06:1018160
119/23/20210:04:4178259/23/20210:28:4878259/23/20210:25:067825
129/24/20210:05:2080179/24/20210:41:2780179/24/20210:11:2712845
139/25/20210:03:202979/25/20210:01:492979/25/20210:00:57297
149/26/20210:03:193009/26/20210:01:313009/26/20210:02:10300
159/27/20210:05:1441179/27/20210:42:5541179/27/20210:03:484117
169/28/20210:02:5138519/28/20210:18:3438519/28/20210:05:023851
179/29/20210:07:4439519/29/20210:15:2639519/29/20210:03:333951
189/30/20210:06:5367589/30/20210:26:2367589/30/20210:05:536758
1910/1/20210:07:57203110/1/20210:39:03203110/1/20210:10:152031
2010/2/20210:04:2528110/2/20210:03:5428110/2/20210:01:23281
2110/3/20210:03:5626210/3/20210:01:0326210/3/20210:01:10262
2210/4/20210:07:28770310/4/20210:33:10770310/4/20210:12:377703
2310/5/20210:10:33898610/5/20211:03:34898610/5/20210:12:438986
2410/6/20210:09:221707310/6/20212:22:561707310/6/20210:09:2117073
2510/7/20210:01:28120410/7/20210:04:58120410/7/20210:00:561204
Sheet6
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

ravi2628

Board Regular
Joined
Dec 20, 2017
Messages
209
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
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.


Cell Formulas
RangeFormula
M3M3=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:N18N3=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:O18O3=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:M18M4=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
CellAllowCriteria
Q1ListPTDE,VPT,RPTL






1633949338463.png
 

Forum statistics

Threads
1,147,481
Messages
5,741,397
Members
423,657
Latest member
Medrok2021

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top