please help me make a chart with this information

KEY:

TAT turnaround time

MF Monday through Friday

SS Saturday and Sunday

D- Day

E Evening

N Night

Put this data into an Excel spreadsheet and create multiple graphs that will show the relationship between TAT and the other factors.

HELPFUL HINTS: TAT should be your vertical side of the graph. You will want a graph with Test, Shift, Day and Floor data displayed on the horizontal side of your graph. You will create 4 separate graphs.

SPECIMEN	TAT	TEST	DAY	SHIFT	FLOOR
1	1.5	CBC	MF	D	3B
2	2	LYTES	MF	D	3A
3	4	CBC	MF	E	3B
4	0.5	BUN	SS	E	4B
5	4.5	LYTES	SS	D	4B
6	1	GLC	MF	D	4A
7	3.5	CBC	MF	E	3A
8	2	LYTES	MF	D	4C
9	4.5	CBC	MF	N	3B
10	2.5	CBC	SS	D	3C
11	5.5	CBC	MF	E	4B
12	1	BUN	MF	D	3A
13	4.5	LYTES	MF	E	3B
14	2	GLC	MF	E	3B
15	4.5	GLC	SS	N	4A
16	4.5	CBC	MF	D	3A
17	1.5	LYTES	MF	D	3A
18	2	BUN	MF	D	4B
19	5	GLC	SS	N	4C
20	2.5	CBC	MF	D	3C
21	4.5	GLC	SS	N	4A
22	3	CBC	SS	E	4C
23	0.5	LYTES	MF	N	3A
24	5	LYTES	MF	D	3C
25	0.5	CBC	MF	D	4B
26	1	LYTES	MF	D	4C
27	4	LYTES	MF	E	4A
28	1.5	CBC	SS	E	3C
29	1	BUN	MF	N	4C
30	4	GLC	MF	D	3A
31	2	GLC	SS	D	3C
32	3	CBC	MF	D	4B
33	2.5	LYTES	SS	D	3C
34	2	GLC	MF	E	4A
35	5	CBC	SS	D	3B
36	1	CBC	MF	D	4C
37	1.5	LYTES	MF	E	3C
38	4.5	BUN	MF	N	3B
39	2	CBC	MF	D	3C
40	4	LYTES	MF	N	4A
41	2	LYTES	MF	E	4B
42	3.5	CBC	MF	D	3A
43	2.5	BUN	MF	D	3C
44	1.5	GLC	MF	N	3A
45	4.5	BUN	SS	N	3B
46	1.5	CBC	MF	D	4C
47	3	BUN	SS	D	3A
48	2	GLC	MF	E	3C
49	4	CBC	MF	N	3C
50	1	LYTES	MF	N	4B
51	2	CBC	SS	D	3C
52	5	LYTES	MF	D	4A
53	2	GLC	MF	D	3C
54	4.5	GLC	SS	E	4B
55	2.5	GLC	MF	E	4B
56	2	LYTES	SS	D	3A
57	5	CBC	MF	N	3B
58	2.5	BUN	MF	D	3C
59	1.5	GLC	MF	N	4C
60	2	CBC	MF	D	4A
61	4.5	BUN	MF	D	4C
62	0.5	LYTES	SS	E	3C
63	4.5	CBC	MF	N	4A
64	3	CBC	MF	D	3C
65	2	GLC	MF	E	3A
66	4	GLC	SS	E	3C
67	2.5	LYTES	MF	D	3C
68	3.5	GLC	MF	D	4C
69	4.5	LYTES	MF	E	4B
70	1	CBC	SS	D	4B