Forum Discussion
It should be so simple…
I just need to show 100 start stop dates for 100 projects on a gantt chart. I am struggling to achieve it on excel as well. Any suggestions friend?
RJP --
Creating a master project to accomplish this reporting need would be way simpler than trying to create this in Excel. What you are asking is not as simple as you think it should be, which is that you want to report on high-level information about every project in your portfolio. This is not simple in Microsoft Project desktop, which is the tool you are using; but is a built-in feature of both Project Online and Project Server.
So, I think you should create the master project in Microsoft Project with the columns you want to see, and then save the master project. Whenever you update any of the 100 projects, the updates will flow into the master project automatically. Hope this helps.
I just need to make 100’s of project files, just to put a start stop date in…. Looong time. I have a client that wants to a gantt of when we start and stop all sorts, from ppms, reactives to big projects… I have all the data i need in excel, just knowing where to dump it to just do this for me without making up 330 files i have 330 jobs….
If this is something that needs to be updated weekly/monthly by the customer I would look for a more robust solutions and put it in Project or Planner Premium. If this is something you will be doing periodically try the following options.
Assuming there are no dependencies among the 100's of projects in your list this can be done in Excel or directly connected to Power BI.
For Excel, go to File, New then search for a Gantt template.xls, which you should be able to easily modify to accept missing columns then just copy/paste your data,
For Power BI, connect directly to your Excel file to ingest the data then add a custom Gantt visual. Be forewarned as many of the Gantt custom visuals leave a lot to be desired.
