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 |
#2
|
|||
|
|||
Excel Holiday Roster Calender
Just put the dates across the top row, names in the first column. Where
someone is off, insert an X then select all the cells and use conditional formatting with an Equal test against X, and click Format, Pattern tab, and set to a visible colour -- HTH RP (remove nothere from the email address if mailing direct) "ksp" wrote in message ... 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 |
#3
|
|||
|
|||
Excel Holiday Roster Calender
Thanks Bob, I was after something a little more automated but you got me thinking along the right track, and with a few vlookups to populate the fields with X's and some conditional formatting I got my grid Thanks for the insperation KP -- ksp ------------------------------------------------------------------------ ksp's Profile: http://www.excelforum.com/member.php...fo&userid=6267 View this thread: http://www.excelforum.com/showthread...hreadid=482139 |
Reply |
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) |