Forum Discussion
Solved
Schedule Report
Is a view/report similar to this possible in MS Project? our plant is used to seeing an Excel spreadsheet like this, which is very efficient. Basically, it's a Gantt chart where each cell is a task...
- RobertOrnelas,
Yeah Project has a lot of subtle options that can make all the difference.
1. Double click on the summary line to bring up the task information window. Check the "Hide Bar" option. That will hide the summary line bar but allow rolled up subtask bars to appear, as long as the Rollup field is marked ad "yes" for the summary and all subtasks.
2. There is no "Subtask Name" field, the field is simply "Name", as shown in my screenshot.
Does that help?
John
Robert Ornelas,
You say you developed macros to make it behave like a schedule. What exactly do the macros do with respect to the data on the spreadsheet you show?
You also mention a "cell" being a task. Help us out here, we can't read your mind, all we see is a spreadsheet with some data in columns and some type of timescaled data. We have no idea what the data in the columns represents nor do we have an inkling on what is represented by the timescaled data.
If you can expand upon what you need from Project, perhaps we can suggest a way to get there.
John
You say you developed macros to make it behave like a schedule. What exactly do the macros do with respect to the data on the spreadsheet you show?
You also mention a "cell" being a task. Help us out here, we can't read your mind, all we see is a spreadsheet with some data in columns and some type of timescaled data. We have no idea what the data in the columns represents nor do we have an inkling on what is represented by the timescaled data.
If you can expand upon what you need from Project, perhaps we can suggest a way to get there.
John