Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Holiday/Sickness chart
I have to compose a chart for the year showing a column of names for
everybody in my company, and then put the various absences in. I was wondering if I can make a kind of drop down list, or perhaps colour code the cell depending on the kind of leave taken. It would be based on a monthly calender so 1-31 would be the columns with the rows showing names and i would have 12 tabs for each month of the year. Any help would be appreciated. Many thanks |
#2
|
|||
|
|||
Hi Jules
Take a look at Debra Dalgliesh's site for easy instruction on creating a drop down list. http://www.contextures.com/xlDataVal01.html -- Regards Roger Govier "jules" wrote in message ... I have to compose a chart for the year showing a column of names for everybody in my company, and then put the various absences in. I was wondering if I can make a kind of drop down list, or perhaps colour code the cell depending on the kind of leave taken. It would be based on a monthly calender so 1-31 would be the columns with the rows showing names and i would have 12 tabs for each month of the year. Any help would be appreciated. Many thanks |
#3
|
|||
|
|||
Thanks for your help. I'll be sure to take a look.
Regards "Roger Govier" wrote: Hi Jules Take a look at Debra Dalgliesh's site for easy instruction on creating a drop down list. http://www.contextures.com/xlDataVal01.html -- Regards Roger Govier "jules" wrote in message ... I have to compose a chart for the year showing a column of names for everybody in my company, and then put the various absences in. I was wondering if I can make a kind of drop down list, or perhaps colour code the cell depending on the kind of leave taken. It would be based on a monthly calender so 1-31 would be the columns with the rows showing names and i would have 12 tabs for each month of the year. Any help would be appreciated. Many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Editing a Chart Directly?? | Charts and Charting in Excel | |||
Chart formatting | Charts and Charting in Excel | |||
Problem with xlusrgal.xls file | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel | |||
Why do my text boxes disappear from my chart when I click out? | Charts and Charting in Excel |