Help needed-use a bar chart

[martynmordecai]

I am Cuttently creating a schedule in excel for work. the schedule will look like this:

Name.........................Shift
Andrew.......................6-3
Jonathon....................12-7
Kim............................9-5

etc etc



the thing is though this is simple enough but i am trying to use a bar chart to help me show how many people i will have on shift at anytime e.g


time...........amount of people working
6-7................. 1
7-8 ................ 1
8-9 ................ 1
9-10 ................. 2
10-11................. 2
11-12 ............... 2
12-1 ................ 3
1-2 .................. 3
2-3 ................. 3
3-4 ................. 2
4-5 ................. 2
5-6 ................ 1
6-7 .................. 1
7-8 .................. 1
8-9 ................ 1


anyone know how i can achieve this???

cheers martyn
Edit/Delete Message

[shg]

Duplicate post, thread closed.