Chart creation - best presentation?

[ur_uncle]

Hi all,

Need some assistance trying to get this presented correctly in a bar chart.

Y axis as times, earliest as the starting point.

X axis showing each day, with values of # staff vs. # covers.

Can anyone help?

Thank you!

Time Card Report Analysis.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1		Monday		Tuesday		Wednesday		Thursday		Friday		Saturday		Sunday
2	TIME	# Staff	# Covers	# Staff	# Covers	# Staff	# Covers	# Staff	# Covers	# Staff	# Covers	# Staff	# Covers	# Staff	# Covers
3	5:00:00 AM	1	0	1	0	1	0	1	0	1	0	1	0	1	0
4	6:00:00 AM	1	0	1	0	1	0	1	0	1	0	1	0	1	0
5	7:00:00 AM	3	0	1	0	1	0	1	0	1	0	1	0	1	0
6	8:00:00 AM	15	0	7	0	4	0	4	20	5	0	4	0	5	1
7	9:00:00 AM	14	0	16	0	31	53	4	0	6	4	6	2	18	2
8	10:00:00 AM	36	0	36	0	46	0	14	2	17	0	21	1	38	36
9	11:00:00 AM	43	73	48	58	54	63	25	50	28	46	34	81	43	147
10	12:00:00 PM	48	149	53	165	59	141	27	165	31	118	37	164	45	139
11	1:00:00 PM	50	136	55	95	60	88	29	77	41	115	37	77	44	84
12	2:00:00 PM	51	47	54	20	59	27	29	11	42	34	36	21	44	30
13	3:00:00 PM	50	56	52	28	57	19	27	37	44	65	31	55	44	12
14	4:00:00 PM	47	78	49	75	58	105	32	81	52	174	29	23	40	30
15	5:00:00 PM	45	116	53	225	66	162	39	162	59	242	34	91	39	104
16	6:00:00 PM	43	149	53	166	64	227	39	175	60	278	30	142	38	209
17	7:00:00 PM	43	72	51	101	61	227	39	111	60	156	30	236	36	54
18	8:00:00 PM	40	3	39	97	58	29	37	10	60	57	28	12	32	2
19	9:00:00 PM	27	0	20	0	30	0	28	0	52	34	22	0	19	2
20	10:00:00 PM	17	0	10	0	15	0	6	0	6	0	6	0	19	0
21	11:00:00 PM	3	0	0	0	0	0	0	0	1	0	0	0	0	0
22	12:00:00 AM	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Summary

Cell Formulas
Range	Formula
B3:O22	B3	='2022-01-17'!M3

 

[ur_uncle]

Just realized data values are formulas and might be easier if hard values.

any help is appreciated,

Sample.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Date	Monday		Tuesday		Wednesday		Thursday		Friday		Saturday		Sunday
2	Time	# Staff	# Covers	# Staff	# Covers	# Staff	# Covers	# Staff	# Covers	# Staff	# Covers	# Staff	# Covers	# Staff	# Covers
3	5:00:00 AM	1		1		1		1		1		1		1
4	6:00:00 AM	1		1		1		1		1		1		1
5	7:00:00 AM	3		1		1		1		1		1		1
6	8:00:00 AM	15		7		4		4	20	5		4		5	1
7	9:00:00 AM	14		16		31	53	4		6	4	6	2	18	2
8	10:00:00 AM	36		36		46		14	2	17		21	1	38	36
9	11:00:00 AM	43	73	48	58	54	63	25	50	28	46	34	81	43	147
10	12:00:00 PM	48	149	53	165	59	141	27	165	31	118	37	164	45	139
11	1:00:00 PM	50	136	55	95	60	88	29	77	41	115	37	77	44	84
12	2:00:00 PM	51	47	54	20	59	27	29	11	42	34	36	21	44	30
13	3:00:00 PM	50	56	52	28	57	19	27	37	44	65	31	55	44	12
14	4:00:00 PM	47	78	49	75	58	105	32	81	52	174	29	23	40	30
15	5:00:00 PM	45	116	53	225	66	162	39	162	59	242	34	91	39	104
16	6:00:00 PM	43	149	53	166	64	227	39	175	60	278	30	142	38	209
17	7:00:00 PM	43	72	51	101	61	227	39	111	60	156	30	236	36	54
18	8:00:00 PM	40	3	39	97	58	29	37	10	60	57	28	12	32	2
19	9:00:00 PM	27		20		30		28		52	34	22		19	2
20	10:00:00 PM	17		10		15		6		6		6		19
21	11:00:00 PM	3		0		0		0		1		0		0
22	12:00:00 AM	0		0		0		0		0		0		0
Sheet1

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: How to present data correctly in bar chart
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.