| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel Holiday Roster Calender
My boss wants a visual representation of what staff have booked annual leave over the Xmas / New Year period. He is saying that he would like a calender type view that has what amounts to a bar chart type representation of what days in say December each staff member is going to be off on annual leave. I have all the details of the start and end dates of staff's annual leave already in excel but need to find a way to convert this into either a bar chart or just an excel grid that has use some conditional formatting to shade the annual leave days Does anyone have any suggestions ? Many thanks in advance KP -- ksp ------------------------------------------------------------------------ ksp's Profile: http://www.excelforum.com/member.php...fo&userid=6267 View this thread: http://www.excelforum.com/showthread...hreadid=482139 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
| Excel Files Acting Weird | Excel Discussion (Misc queries) | |||
| Can I use a spreadsheet to populate an offline calender in excel? | Excel Discussion (Misc queries) | |||
| Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
Threaded Mode
