Go Back   TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to make this graph? BCWS S-curve over time

Microsoft Project


Reply
 
Thread Tools Search this Thread
  #1  
Old 20-08-2010
Member
 
Join Date: Mar 2009
Posts: 10
How to make this graph? BCWS S-curve over time

How do I make this graph on pg 6 (http://www.projectlearning.net/pdf/I2.1.pdf) in MS project 2003/2010 .

My manager is asking to see total BCWS by resource and percentage of budgets.


Thanks

Reply With Quote
  #2  
Old 22-05-2011
Member
 
Join Date: Nov 2009
Posts: 751
Re: How to make this graph? BCWS S-curve over time

There less know information on that option in MS project. By the way the program is conceptualized do not think you can associate the activity directly as well as we do with the written comments, as you well you say we are going to handle graphics and the manager would still not have the P3 or MS project. You can create a graphical database which would be easier to pear when making your presentation. But my answer for now is that there is a direct function.
Reply With Quote
  #3  
Old 04-01-2014
Member
 
Join Date: Jun 2013
Posts: 109
Re: How to make this graph? BCWS S-curve over time

Even I am facing similar issues with BCWS. I have tried to set the Preject status Date to the last date of the project and exporting BCWS values to excel I was suppose to be able to have a projected S-curve for all the timeline of the project which will work as a frozen baseline to track project performance advances. But if I am updating Project progress and changing the status date to a previous date so that I can see how the project is performing then I get that BCWS values for the same dates changed so how is it possible? Thanks
Reply With Quote
  #4  
Old 06-01-2014
Member
 
Join Date: Jun 2009
Posts: 1,107
Re: How to make this graph? BCWS S-curve over time

BCWS is calculated by Project only upto the status date. Once the date is over then BCWS shoud be 0. From your stored baseline BCWS comes which is fixed. So to retain an S curve, you will have to just export and after that you need to manually take your BCWP and ACWP and each status date and then expand your graph in Excel. Hope this helps.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to make this graph? BCWS S-curve over time"
Thread Thread Starter Forum Replies Last Post
How to make a visual report on a s curve jd.toit Microsoft Project 9 08-02-2012 12:20 AM
How to get Line Curve formula without a graph in Microsoft Excel vALaNCiA MS Office Support 8 07-02-2012 06:59 PM
Searching for template of bell curve graph in excel Rao's Windows Software 2 06-01-2012 01:04 PM
Charting a curve in real time spuff Software Development 11 29-09-2008 02:38 PM


All times are GMT +5.5. The time now is 09:31 PM.