Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-23-2012, 09:54 AM
carswelljr carswelljr is offline s-curve Windows XP s-curve Office 2007
Novice
s-curve
 
Join Date: Aug 2012
Posts: 3
carswelljr is on a distinguished road
Default s-curve


Hello everyone,
I need to create a s-curve, I have found exact software to meet my needs but I was wondering is there a way to generate this in MS Project 2007 by using web parts? excel? etc.
If I could create this myself it would help tremendously.
thanks in advance
Reply With Quote
  #2  
Old 08-24-2012, 04:46 AM
ketanco ketanco is offline s-curve Windows 7 64bit s-curve Office 2007
Expert
 
Join Date: Dec 2011
Posts: 269
ketanco is on a distinguished road
Default

it is easy:
-first make your schedule
-assign costs to your activities either by putting in fixed costs or by resources
-go to task usage tab
-at the right section of the screen you will see some rows
-right click there and make sure you add cumulative cost row
-you will see that the cumulative costs distributed from left to right all the way from the start to the end for each activity (with respect to your project calendar span at the top)
-then all you do is to paste the top row which is the calendar to excel and then paste the cumulative row to the excel exactly under that first row so you have two rows under each other in excel (make sure dates and costs correspond as in ms project)
-then you can make a graph in excel showing an s curve with one axis being the time and the other cost
hope this helps
Reply With Quote
  #3  
Old 08-24-2012, 05:19 AM
JulieS JulieS is offline s-curve Windows 7 64bit s-curve Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Quote:
Originally Posted by carswelljr View Post
Hello everyone,
I need to create a s-curve, I have found exact software to meet my needs but I was wondering is there a way to generate this in MS Project 2007 by using web parts? excel? etc.
If I could create this myself it would help tremendously.
thanks in advance
Have you looked at the Visual Reports in Project 2007? They create pivot tables and pivot charts.
Reply With Quote
  #4  
Old 08-24-2012, 08:54 AM
carswelljr carswelljr is offline s-curve Windows XP s-curve Office 2007
Novice
s-curve
 
Join Date: Aug 2012
Posts: 3
carswelljr is on a distinguished road
Default

Hi ketanco,
Thank you for responding to my post. We are currently doing it the way you described, however I wanted to see if there was a easier or better way without having to copy and past. Like a macro that could be written in excel or exporting the project schedule to csv and importing into excel? something that generates a s-curve for the stakeholders who will not know or want to go through the steps.
Reply With Quote
  #5  
Old 08-27-2012, 05:45 AM
JulieS JulieS is offline s-curve Windows 7 64bit s-curve Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Yes, of course you can write a macro to export the data to Excel - but again - have you looked at the visual reports? It is also not clear from your post what data you wish to plot in an S-curve. If you are looking for the standard Earned Value data - it's already made for you in visual reports.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
text on a curve janiceams Word 1 11-18-2009 04:25 AM
s-curve Curve the Text Box in a Newsletter? lewiedude Publisher 2 11-08-2005 08:52 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 04:29 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft