Using excel display a roster as hourly coverage in units

[Matt]

I am Trying to display a roster by name and colour to show coverage at a
glance.
It would be nice if each hour worked coued be displayed as a unit or
portionof a unit

any suggestions????

[Steve]

Matt

Its difficult to determine exactly what your problem is. However, I preume
the problem may be that you run multiple rosters. If this is the case, why
not chart your day in time increments to suit along the x axis and use a
stacked chart to display the numbers of staff provided by each roster.

This is a really effective technique if you chart it in front of an area
chart of workload demand.

Steve


"Matt" <Matt@discussions.microsoft.com> wrote in message
news:2CA705DE-3C0A-44F0-8984-454FA1758AF3@microsoft.com...
>I am Trying to display a roster by name and colour to show coverage at a
> glance.
> It would be nice if each hour worked coued be displayed as a unit or
> portionof a unit
>
> any suggestions????