The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

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

Resolved · Low Priority · Version Standard

ReplyWed 29 Nov 2006, 07:47Dave Grant (guest) said...

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

For upcoming training course dates see: Pricing & availability

ReplyThu 30 Nov 2006, 16:40Trainer Andrew said...

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 articles

· Multi-tasking With Microsoft Project
· Understanding Critical Path In Project
· MS Project: Project Manage your way to becoming a Home Owner
· Three Ways to Make Microsoft Projects Courses More Effective
· An Introduction To Tracking In Microsoft Project

Ms project tip:

Using the Quick Access Toolbar in Project 2010

The Quick Access Toolbar is included in virtually every Office product, including Project 2010 as well as Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all MS Project hints and tips

Please confirm /advise in respect of the creation of float and slack and milestones/constraints

» Forum post: Microsoft project

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions