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
Member for
13 years 8 months
Member for13 years8 months
Submitted by Shahnawaz Akter on Tue, 2012-11-06 21:20
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.
Member for
17 years 9 monthsHello Shahnawaz, Go to
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
Member for
13 years 8 monthsCan any body tell the steps
Can any body tell the steps for making S-Curve in excel against MH and time from my p6 plan
Member for
13 years 8 monthsCan any body tell the steps
Can any body tell the steps for making S-Curve in excel against MH and time from my p6 plan
Member for
16 years 11 monthsHai Nick, Depends on what
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.