ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Using excel display a roster as hourly coverage in units (https://www.excelbanter.com/excel-worksheet-functions/16070-re-using-excel-display-roster-hourly-coverage-units.html)

Steve

Using excel display a roster as hourly coverage in units
 
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" wrote in message
...
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????





All times are GMT +1. The time now is 12:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com