Holiday planner
Todays template is a holiday planner. It is a stacked bar chart and the worksheet contains a few lines of vba code to self adjust min and max date in the chart. The chart adds new names as you type them.
VBA code in sheet1
Private Sub Worksheet_Change(ByVal Target As Range)
ActiveSheet.ChartObjects("Chart 2").Activate
ActiveChart.Axes(xlValue).MinimumScale = _
Application.WorksheetFunction.Min(Range("Start")) - 7
ActiveChart.Axes(xlValue).MaximumScale = _
Application.WorksheetFunction.Max(Range("End")) + 7
ActiveWindow.RangeSelection.Select
End SubThe workbook contains dynamic named ranges, you can find instructions in this post:
Dynamic Gantt charts in excel 2007
Download excel *.xlsm file
Here is another version that allows you to enter two date ranges.
Download excel *.xlsm file
Welcome! I am Oscar and here to help you! Feel free to comment and ask excel questions.Don´t forget to add my
February 20th, 2012 at 2:45 pm
can we mark intersection areas with different colors.
February 22nd, 2012 at 7:07 am
You must be my hero!
İf every person have a limit day to take holiday in a year (different days for every person) and also other rights to allow previous year. So how can we see in the same table.
For example x person's right to allow for 2007-14 days,2008-14 days...but he/she take 2007-5 days, 2008-16 days so now he/sha has x days holiday rights. Could we add this chart another sheet for to follow in general status of the employees.May be we may see chart by depts.
Thank you by now.
February 22nd, 2012 at 10:35 pm
Mustafa,
I am not sure how.
February 22nd, 2012 at 10:39 pm
Thanks for your reply Oscar, I`ll research on this situation. If i find something useful I`ll write you too. Thanks again for the template, it`s really good looking.
Actually I`m subscribing your post for a long time, you are really working awesome.