Help with MS Excel S-Curve

Thank you Excel day savers!

Please see a screen shot of my worksheet data.

Also, what I meant with % completion is percentage completion as in:
An S-curve that will be used to check during construction when pay requests are submitted
to check the actual progress against the schedule.


This was my review for the earnings curve attached:
“I reviewed the earnings curve, but unfortunately it is still not correct.
The 2nd curve now seem to show the actual cost, based on % completion, but it needs to be accumulative, which it is not.
In an accumulative curve, the curve will always go up when there is a payment and horizontal when there is no payment.
However, the curve can never go down."


Thanks for your taking the time to reply!