Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft-project-training-courses - scurve earned value

Forum home » Delegate support and help forum » Microsoft Project Training and help » microsoft-project-training-courses - S-Curve, Earned Value

microsoft-project-training-courses - S-Curve, Earned Value

ResolvedVersion Standard

S-Curve, Earned Value

Is there a way to get Project to provide automatically an S-Curve chart as part of a report? I want to show earned value (in cost or hours) against time, and show both the Baseline and the Actual & Forecast earned value for trend comparison.

I'd also like to be able to get a chart that plots CPI against SPI and retains the data over time to enable me to show how these performance indices change through the course of a project

RE: S-Curve, Earned Value

To produce your S-Curve you will need to get your data out of Project into Excel. Project includes a toolbar to help you do this.

From the view menu choose Toolbars then Analysis

From the toolbar you will find an Analyze Timescaled Data in Excel Button. This will take you through a series of steps to export your information to Excel where you can then create the charts you require.

Let us know if you have further questions.

Andrew

MS Project tip:

MS Project 2010 Scroll to Task

Ever feel lost on a large project file? In Gantt view, Task ribbon, Editing, click on the Scroll to Task tool to centre the task bar on your screen.

Shortcut Ctrl+Shift+F5

Same as Go to Selected Task in MS Project 2003.

View all MS Project hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.