Complicated excell question, & I'm not going to tell you how I am trying to do it, so you can tell me I am doing it wrong

[KatyMac]

I'd rather explain what I am doing and see if anyone can come up with a solution

If that makes sense

I want a table with children's start & finish times in it

I want to creat a coloured barchart (I think that's what it's called) showing the hours of attendance

I don't think that makes any sense at all - but then it has been a bit of a complicated day

Can I make each line a different colour?

Do you know I'm not even sure it is a Gantt chart I want

Currently I have a table per week

Each day has children attending

The children attend different hours each day

The days are split into 15min slots - but only labelled every half hour

Actually I want it to make it all itself

& it's vertical not horizontal

I think I'm going to pay someone to do this for me - it's not fair to keep asking for help for such complicated stuff

It is Lapin - honest, Kevlarhead did something great for me last night I just don't really understand it & I can't tweak it

I'll email it - but don't waste time on it - it's work stuff not fun