Forum Discussion
RJP
Jan 07, 2025Copper Contributor
It should be so simple…
Hello i have to show 100 projects, on one sheet, with just start date and stop date for each project. So showing start stop dates of a portfolio of projects. i have project names, work order numbe...
RJP
Jan 08, 2025Copper Contributor
Hi John
i mention excel as thats where i have job title, start and stop dates… ie copy paste easily.
what i am trying to do is still the same!
have a gantt line for all 100 jobs (i actually have 330) on one page showing job, start, stop, gantt line to the dates.
i have tried doing it in excel and it just doesn’t cone out any good… not something you would want to present.
now making 330 project files would take a loooong time eh
John-project
Jan 09, 2025Silver Contributor
RJP,
From everything you said in your replies to Dale and to myself, I'm still trying to wrap my head around exactly what you have.
- In what application is your "portfolio of projects" (i.e. Excel, Project, or something else)?
- Do your "projects" consist of only a name (job), start, and stop or is there more to each "project"?
- You said you tried doing it in Excel. What exactly did you do in Excel?
I'm sorry but I;m more confused now about what you have then I was when I read your original post. A screen shot of what you have would likely help clear up some of my confusion.
John