Forum Discussion
Formula for gannt-charts in projects
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?
Present your data in a Gantt chart in Excel
hough Excel doesn’t have a predefined Gantt chart type, you can create one using these free Gantt chart templates.
See Also
Create a chart from start to finish
How to use Gantt Chart in Excel for project management
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and Like it!
This will help all forum participants.
