s-curve in ms project

A
Ammar Samad 👤 Member for 18 years 10 months
M
mohd fakry 👤 Member for 19 years 8 months

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 I’ll do after that is just simply copy and past into excel and further customize into chart. I hope this will help.









m.fakry

A
Alexandre Faulx-Briole 👤 Member for 23 years 4 months

Mohammed,

you are right, there is still some work to do to fix the table; a excel macro would help!

Alexandre

A
Ammar Samad 👤 Member for 18 years 10 months

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




A
Alexandre Faulx-Briole 👤 Member for 23 years 4 months

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

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts