Help with graph please

[kgkev]

I avoid graphs at all costs normally but have been asked to show some data as a bar graph


My Data is

Excel Workbook
	A	B	C	D	E	F	G	H	I
1	W/E	Week 1		Week 2	*	Week 3	*	Week 4	*
2	Engineer	Work/Travel	Not on site	Work/Travel	Not on site	Work/Travel	Not on site	Work/Travel	Not on site
3	Bill	60	0	28	12	0	40	0	40
4	Joe	48	0	85	0	40	0	34.5	0
5	Dave	47.5	0	32	5.5	40.5	0	42.5	0
6	Brian	40.5	0	47.5	0	44	0	50	0
7	Ian	36	7.5	35.5	0	12.5	25	40.5	0
8	Karl	60	0	40	0	0	40	0	0
9	John	46	0	56	0	64	0	64	0
10	Kevin	45.5	0	61	0	18.5	0	36.5	0
February

I want it to look similar to



thanks

 

[tusharm]

What do the black and red bars represent? How do they relate to Bill's 60/0, 28/12, 0/40, and 0/40 numbers?

 

[kgkev]

They don't relate to the data.

The black data shows Travel / Work the red shows Not on site.