98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
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
Resolved · Low Priority · Version Standard
Wed 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
Thu 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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
MS Project tip:Autofit column width – Project (all versions)At the top of the columns where each column name is located (Task Name, Duration, etc.), hover over the vertical column line which you want to move. |
