Scurve creation in excel

Hi Everyone

I have been given a template to create an S-curve Report.

I have the project data but im unsure how to massage this into the scurve report to get the desired result.

If there are any gurus out there willing to take a look please let me know.

B
Berker Colakoglu 👤 Member for 18 years 6 months

Hello Shahnawaz,

 

Go to Assignments Page ,use filter resource type equals labor ,right click to right side then go the spreedsheet fields and click customize. Select Budgeted units and Actual Units.

Select required data then copy and paste to excel.

From excel click insert tab and click charts to generate your S-Curve. (Generally i use columns chart for budgeted and actual units and line chart for cumulative units)

Then modify it accordingly.

 

Regards,

 

Berker Colakoglu

S
shahnawaz akhtar 👤 Member for 14 years 5 months

Can any body tell the steps for making S-Curve in excel against MH and time from my p6 plan

S
shahnawaz akhtar 👤 Member for 14 years 5 months

Can any body tell the steps for making S-Curve in excel against MH and time from my p6 plan

M
mukunda y 👤 Member for 17 years 8 months

Hai Nick, 

Depends on what basis u want to plot s curve based on Duration, weightage, cost or resource, ..after doing this export from the software to spreadsheet, plot the s curve % against Time.

Featured Partner

Top Posters

Rahul Kumar
1 posts
blake333_
0 posts
Jeamiell Ostrovsky
2 posts
Hamzah Ahmed
0 posts
Quinton van Eeden
3 posts
Sunchana Johnston
12 posts
Akram Hammam Mohamed
17 posts
Sagar Raut
14 posts
Patricio_aoa
0 posts
James Williams
75 posts