Project Management

Please login or join to subscribe to this thread

snake diagram in MS Project

linkedin twitter facebook  
avatar
Torge Oeverdiek Danfoss Editron Sh, Germany
Hi team , I want to create a snake diagram for my project schedule. This is a diagram showing Cumulative duration on the Y axis and Critical Path Milestone Number on the X axis. It plots the Actual Time to completion for each milestone vs Schedules Time to Completion for the same . It's an excellent way to visualize schedule health (deviation of Actual vs. baseline completion dates for milestones) but for some reason I cannot find a way to create such a view in MS Project. Can somebody help? Prob I am missing something obvious here :D
Sort By:
avatar
Kiron Bondale Retired | Mentor| Retired Welland, Ontario, Canada
Torge -

I have MSP Professional 2019 (not the latest version) and I don't believe there's a built-in report for this. However, you could likely either create it as a new custom report or worst case use the Visual Reports capability to export the raw data for milestone actual finish date vs baseline finish date to MS Excel and subtract the project start date from those to be able to generate the chart.

Kiron
...
1 reply by Torge Oeverdiek
Apr 21, 2023 4:41 AM
Torge Oeverdiek
...
Hi, this helps thank you.
avatar
Abolfazl Yousefi Darestani Manager, Quality and Continuous Improvement| Hörmann-TNR Industrial Doors Newmarket, Ontario, Canada
Years ago, I created something similar to this using Excel. The data extracted from MSP.
...
1 reply by Torge Oeverdiek
Apr 21, 2023 4:41 AM
Torge Oeverdiek
...
ok - thank you !
avatar
Aaron Porter
Community Champion
IT Director| Blade HQ Payson, UT, United States
Here are the closest things in Project that I can think of, but I'm not sure either is exactly what you're looking for:

- a custom report using the Comparison template.
- tracking Gantt that shows the baseline vs changes
...
1 reply by Torge Oeverdiek
Apr 21, 2023 4:42 AM
Torge Oeverdiek
...
Ok - haven't checked the tracking gantt for this use yet - will do it
avatar
Latha Thamma reddi Sr Product and Portfolio Management (Automation Innovation)| DXC Technology Mckinney, Tx, United States
Years ago, I also used very near to similar with excel.
...
1 reply by Torge Oeverdiek
Apr 21, 2023 4:42 AM
Torge Oeverdiek
...
ok good thank you
avatar
Torge Oeverdiek Danfoss Editron Sh, Germany
Apr 20, 2023 7:47 AM
Replying to Kiron Bondale
...
Torge -

I have MSP Professional 2019 (not the latest version) and I don't believe there's a built-in report for this. However, you could likely either create it as a new custom report or worst case use the Visual Reports capability to export the raw data for milestone actual finish date vs baseline finish date to MS Excel and subtract the project start date from those to be able to generate the chart.

Kiron
Hi, this helps thank you.
avatar
Torge Oeverdiek Danfoss Editron Sh, Germany
Apr 20, 2023 8:48 AM
Replying to Abolfazl Yousefi Darestani
...
Years ago, I created something similar to this using Excel. The data extracted from MSP.
ok - thank you !
avatar
Torge Oeverdiek Danfoss Editron Sh, Germany
Apr 20, 2023 10:50 AM
Replying to Aaron Porter
...
Here are the closest things in Project that I can think of, but I'm not sure either is exactly what you're looking for:

- a custom report using the Comparison template.
- tracking Gantt that shows the baseline vs changes
Ok - haven't checked the tracking gantt for this use yet - will do it
avatar
Torge Oeverdiek Danfoss Editron Sh, Germany
Apr 20, 2023 3:01 PM
Replying to Latha Thamma reddi
...
Years ago, I also used very near to similar with excel.
ok good thank you
avatar
Thomas Walenta Global Project Economy Expert Hackenheim, Germany
Torge

not sure this helps for your problem, but maybe line of balance / LOB (or linear scheduling) is also a way, used mainly in construction to track schedule vs output.

There are tools supporting LOB, for example spiderproject.com or trimble.

Thomas
avatar
Latha Thamma reddi Sr Product and Portfolio Management (Automation Innovation)| DXC Technology Mckinney, Tx, United States
Thank You!.

Please login or join to reply

Content ID:
ADVERTISEMENTS

You suffer for your soup.

- Kramer

ADVERTISEMENT

Sponsors