Hi everyone, 

I am trying to make a gannt-chart for projects and I encounter the following problem. 

In the picture you see at my company we have different types of projects (full, medium , light , full ctpd). Regarding this there are different types of hours involved every week, so we have made basic scheme for each type of project(see second picture). I would like that Excel returns these rows based on a) the type of project and b) that it starts returning this row from the date (week) the project starts. The conditional formatting between start date and end date is not difficult to format. Secondly return the rows is also not the problem however let the rows start from the start date is difficult. 

Does someone has thoughts on this?

​Hi everyone,  I am trying to make a gannt-chart for projects and I encounter the following problem. In the picture you see at my company we have different types of projects (full, medium , light , full ctpd). Regarding this there are different types of hours involved every week, so we have made basic scheme for each type of project(see second picture). I would like that Excel returns these rows based on a) the type of project and b) that it starts returning this row from the date (week) the project starts. The conditional formatting between start date and end date is not difficult to format. Secondly return the rows is also not the problem however let the rows start from the start date is difficult. Does someone has thoughts on this?    Read More

​