Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.


How to prepare S curve in M S Project

How to prepare S curve in M S Project

We have recently started planning using MS Project-2000. Is there any option to get S curve?
Thanks in anticipation,

RE: How to prepare S curve in M S Project

Not as far as know

I have same Problem and export data to excel



RE: How to prepare S curve in M S Project

Hi Imtiyaz,
Like blooda, I have exported data from the task/resource usage tables to excel, the reason being that you can't hold progressive actuals to measure against the plan curve - all you can pull off are the latest values.
If you want to see a planned curve only, split the window to Gannt & Resource Graph (bottom pane). Then format the graph details to cumulative work (this will give you stepped appearance. Format the bar styles to line. This will give you an s curve for planned work only - unfortunately this is as far as you can go.
Good luck,

RE: How to prepare S curve in M S Project

What I have done to obtain an ADVANCE s curve is to export the activity, start date and finish date, to excel, and make a formula that calculates the distribution of that activity in time with "IF". In columns, the time frame. then I compare the time frame with start and finish date, and it gives me the % of advance of each activity across the time. Then I find the incidence of each activity based on ManPower for example, and make a SUMPRODUCT of the incidences with its advance distribution, and finally obtain a beautiful and realistic s curve of ADVANCE. I can show you the excel file if you want.

Dont have information about resources S curve like Primavera does.

RE: How to prepare S curve in M S Project

please show me that xl file

RE: How to prepare S curve in M S Project

show me that file please.

RE: How to prepare S curve in M S Project

Hi Santo2002,
Thanks for the reply, I am develop something similar by exporting data in excel and using if statements. But it take lot of manhours and also if I revise the baseline, so again I have to do the complete file.
I would love to see your excel spread sheet.


Take care :)

RE: How to prepare S curve in M S Project

You are right imtiyaz, every time you modify the baseline, you must go to the excel file and copy/paste the dates. This must be done every time you revise it / reschedule it.

It wont require a lot of man hours though ;), just copy and paste...

Sad1980, imtiyaz, please send a little message to my email, and I will reply it with the file.

Regards, Santo.

RE: How to prepare S curve in M S Project

Thanks for the reply, I send a message to this address:

Thank you,

RE: How to prepare S curve in M S Project

Primavera will do S-Curves for you.

RE: How to prepare S curve in M S Project

well u can have the s curve in msp itself .go to view-resource graph. right click -choose cumulative cost.then choose bar styles and then choose filtered resources total costs and choose line. click ok there u have ur s curve with cumulative costs shown on vertical and monthly cost on horizontal line. ofcourse primavera has ready s curves

RE: How to prepare S curve in M S Project

The Cube OLAP draws S Curve automatically based on the Work and actual work & Estimate to Complete info

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


eBook: Product Innovation Platform Assessment
Over the past few years, there has been growing interest among industrial companies and solutions providers with regards to Product Innovation Platforms, where design, manufacturing and IoT tools are bundled into a single software package. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close