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]
Erik Jonker
User offline. Last seen 24 weeks 5 days 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?

Replies

Trevor Rabey
User offline. Last seen 13 weeks 5 days ago. Offline
Joined: 29 Nov 2005
Posts: 528
Groups: None
No problem to make a vertical step on a graph in EXCEL.

Erik, if you have the data, I can graph it.
Nicolas Igersheim
User offline. Last seen 2 years 41 weeks ago. Offline
Joined: 25 Jun 2007
Posts: 62
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.