Creating S-Curves in MS Project 2010

Hi I have recently upgraded to MS Project 2010 and the Analyse Time Scale Data tab doesn't exist. Is there another way to create S-Curves on Project % Complete Planned vs Actual

C
Chris Rymer 👤 Member for 15 years 11 months

With Project Tracker you can create S curves directly from Microsoft Project without the need to export the data to a spreadsheet. If you have the XML file you don't even have to have MSP on your machine. It can create the curve from the durations of the activities in your project plan, you do not need resource or cost allocations. For more information and a free trial, go to ww.willmer.co.uk.

R
Ronald St.Hilaire 👤 Member for 17 years 9 months

Alexandre/ Donald,

Would it be possible for me to get your individual e-mail addresses?

Ronald.

R
Ronald St.Hilaire 👤 Member for 17 years 9 months

Alexandre/ Donald,

Would it be possible for me to get your individual e-mail addresses?

Ronald.

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

Donald,

how can you change the units from "hours" to "days"" by right-clicking the Task Usage time-distributed panel?

Alexandre

D
Donald Harrold 👤 Member for 15 years 2 months

Right click on the table and you will be able to change the view to manhours

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

Ronald,

if you want to use the Earned Value Over Time Report, do not "edit" the template, but select the report in the list and click "View"

if you want to do as Donald is suggesting, which is really an easy way to generate a S Curve in MS Excel or any other spreadsheet: display the Task Usage View (not "Report"), copy and paste one after the other the left hand table and the right hand distribution sheet;

be careful to properly paste the data in the spreadsheet side to side

Alexandre

R
Ronald St.Hilaire 👤 Member for 17 years 9 months

Donald

I don't understand if I'm in Task Usage the only thing I'm seeing is a Cash Flow Report.

D
Donald Harrold 👤 Member for 15 years 2 months

The easiest and most flexible way to generate S-Curves is to copy and paste time phased data from the task usage table in to Excel. You will need to format man-hour data to remove the "h" so that Excel interprets the data correctly as numbers.

R
Ronald St.Hilaire 👤 Member for 17 years 9 months

Hi Alexandre,

Thanks for the response. I went into the area put I'm stumped and I was wondering if you could give me some more help

  1. I hit the edit template button
  2. Selected Task % Comp
  3. This where I'm stumped, a prompt came back telling me to select a cost and I could go no further.

Can you guide me from here please? The help would be greatly appreciated.

 

Ronald

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