Need help with a clustered bar or line chart

[switzd0d]

I am trying to make a chart that shows how much wait time my drivers had to wait at EITHER the supplier or here at our site each day. In data below, for example, Hyundai on 1/31/2019 had 1.08 hour wait time while at Hyundai. KIA on 1/28/2019 had 0.57 minutes wait time here at our site. I want a graph that can show who caused the wait time and what day it occurred. Chart style is not important, if a line chart better suits this then that is fine.

What I would like is for the horizontal data to show the days from Sunday-Saturday from left to right. For the vertical scale, it would use the wait times shown below. And for the lines or bars, to show both of the two kinds of wait times either caused at the supplier, here at KAMTEK or both even in rare cases like that Precision Metals.

***I've been playing with this for three hours, time to give up and call in the experts!***
Cells are A1:E11

****Edit: Below is hard to read so I added a image of my excel screen

book1.png

1/31/2019 Hyundai 1.08 KAMTEK
2/1/2019 Hyundai 1.15 KAMTEK
1/28/2019 KIA KAMTEK 0.57
1/29/2019 KIA KAMTEK 2.52
1/28/2019 Precision Metals 0.75 KAMTEK 3.63
1/28/2019 Hyundai KAMTEK 0.83
1/30/2019 Crown KAMTEK 0.52
1/31/2019 Eaglebend 0.17 KAMTEK
1/30/2019 ARJ 2.73 KAMTEK
1/31/2019 Metekote 0.33 KAMTEK
2/1/2019 Metekote KAMTEK 2.14

[BadlySpelledBuoy]

Can be done, pending your responses to clarification questions below...

1) Are you at all interested in a differentiating time spent at the supplier or just a sum total of time spent there?
2) When there is time at both the supplier and KAMTEK, do you want that time included in Supplier/KAMTEK only wait times or excluded from there and shown in its own "Both" series?
3) Whilst I appreciate this is dummy data there seems to be no consistency in time formats. Is 1.08 at Hyundai 1hr8mins or 1.08hrs? If 1hr8mins then what is 0.83 at KAMTEK? 0.83 of an hour or 83 mins?

BSB

[switzd0d]

Hi Bradley, thanks for coming to the rescue!

I slept on it and I think trying to have all the data I was wanting in one graph will be too difficult and not nessessary as it relates to my job. With that being said, I think it will be fine to make two graphs. One to show "Detention Time" (time waiting) while here at KAMTEK and then another graph showing detention time accrued while at the supplier.

So using detention time while here at KAMTEK for example, something like this:

example1.png

This also makes me need to enter the data in differently. Here is the new format:

example2.png

[switzd0d]

Hi guys, I am still trying to figure this out if anyone can help. I'd be extremely grateful.

[JeteMc]

Perhaps the attached will help.
A Pivot Table is linked to the mocked up data, then a pivot chart is produced.
If this doesn't meet your needs then I suggest:
1) Upload the sample data from which the screen shots are made.
2) Use paint to manually draw the type of chart(s) that you want.
To upload files click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.