Forum Discussion

JRivett's avatar
JRivett
Copper Contributor
May 17, 2024
Solved

More than 10 bars in timeline bar

I am using Project to manage a program of works with circa 80 individual projects. The timeline feature is an effective way to summarise project status at a high level but I cannot work out how to ad...
  • John-project's avatar
    John-project
    May 20, 2024

    JRivett 

    Man you must have a pretty slick time machine that you're using Project 2029 already. I guess Microsoft will still be around for at least another 5 years 🙂

     

    Thanks for the screen shot of your high level program file. You mention that the stakeholders want a high level of status of each project. Graphics are a nice visual but a well structured tabular format can sometime be better depending on what program metrics are important to them. You might want to ask them what data is of most interest.

     

    Meanwhile, here is a graphical workaround similar to the Timeline. It doesn't have as much annotation functionality but the visual elements are there and can be used to show more than 10 projects.

     

    Set it up this way:

    1. Go to, Gantt Chart Format > Bar Styles group > Format > Bar Styles

    2. Set up a new Gantt bar style for each project phase (e.g. Feasibility, Consultant, Documentation, etc.). In my example I show 2 elements (Phase 1, Phase 2) but you can have up to 20, one Flag for each element. Note, I set up the bar to show the task Name field inside the bar and I deleted the bulk of Gantt bar styles that are not needed.

     

    3. Once the bar styles are set up apply those to your program file as shown in the example file. Note, you also need to set the Rollup and Hide Bar fields as shown for each project.

     

    4. To create a stakeholders display, set up a filter to isolate each project's summary line. One convenient way to do that is to use the Marked field as shown and create a custom filter or use the AutoFilter to isolate all projects for display.

     

    When the filter is applied, this is the result:

    Hope this helps.

    John

Resources