For me to create any s-curve for any type data, I will always use either the Task Usage View / Resource Usage View. I find it really helpful as we can choose which data to show either cost, resource or work. And what Ill do after that is just simply copy and past into excel and further customize into chart. I hope this will help.
m.fakry
Member for
22 years 9 months
Member for22 years9 months
Submitted by Alexandre Faul… on Tue, 2008-09-23 07:01
1. Schedule your project from the end date and then export your data
2. Display the Task Usage view, then add the Work, Cost, ... and the Early Start/Finish, Late Start/Finish dates, and copu/paste the data into MS Excel
Member for
19 years 1 monthRE: s-curve in ms project
Mohammed,
For me to create any s-curve for any type data, I will always use either the Task Usage View / Resource Usage View. I find it really helpful as we can choose which data to show either cost, resource or work. And what Ill do after that is just simply copy and past into excel and further customize into chart. I hope this will help.
m.fakry
Member for
22 years 9 monthsRE: s-curve in ms project
Mohammed,
you are right, there is still some work to do to fix the table; a excel macro would help!
Alexandre
Member for
18 years 3 monthsRE: s-curve in ms project
Tq Alex,
I have done as your suggestion but I have to arrange the "Work" tabulation MANUALLY. Is that the correct way? Just to confirm..Anyway TQ very much.
Regards
Member for
22 years 9 monthsRE: s-curve in ms project
Mohammed,
MS Project is not really efficient to do that!
You could:
1. Schedule your project from the end date and then export your data
2. Display the Task Usage view, then add the Work, Cost, ... and the Early Start/Finish, Late Start/Finish dates, and copu/paste the data into MS Excel
Alexandre