Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

S-Curve Sawtooth

2 replies [Last post]
Wed, 2008-01-23 06:25
Erik Jonker
User offline. Last seen 4 years 51 weeks ago. Offline
Joined: 19 Apr 2003
Posts: 86
Groups: None
I have some significant additional scope added to my project. I would like to create an sawtooth showing the drop in actual percentage due to the scope increase.

I have done it before in excel, but cannot remember how.

The drop line has to be straight down.

Any help?
Top

Replies

Fri, 2008-01-25 10:21
#1
Trevor Rabey
User offline. Last seen 1 year 21 weeks ago. Offline
Joined: 29 Nov 2005
Posts: 530
Groups: None
No problem to make a vertical step on a graph in EXCEL.

Erik, if you have the data, I can graph it.
Top
Fri, 2008-01-25 09:30
#2
Nicolas Igersheim
User offline. Last seen 7 years 16 weeks ago. Offline
Joined: 25 Jun 2007
Posts: 62
Groups: Petro-Chem / Oil & Gas
To have a vertical drop line would mean you have
two values for the same period => no way in Excel.

You have to paste a different curve for
the modified scope, with no values
until the modif is implemented.

Format the two curves to show the same color for instance.
Add a drawing vertical line to join the two curves.

This is how I would achieve it.
Top