Can MS Project 98 produce the chart shown in the attached file? If no, is there any clever way to get this chart out of MS Project 98? Saving Changes...
Rick, My team at work have link MS Access to MS Project to create EVMS chart simular to your attachement. This may be a solution for your question. Saving Changes...
Jim's solution sounds good, but if you don't have a database implementation of MS Project (and I suggest that you do not use P98, with a resource pool, on a database, as it is unstable) then try this:
1. You must have a baselined project, and you must have been tracking actuals in a sensible way (I could advise if required), 2. Enable the 'Analysis' toolbar using 'View -> Toolbars', 3. Select the 'Analyse Timescaled Data in Excel', 4. Remove the 'work' field from the 'fields to export window' and select the 'ACWP', 'BCWP', 'BCWS' fields to export. 5. Make sure that the 'Status date' in P98 is on the date you require (the export facility in P98 exports data up to this point) 6. Take a look at what you get in Excel.
You will need to manipulate the data a bit, as it will not generate the additional data after the end date (status date). What I suggest is that you export the BCWS field for the entire project separately, and then merge the data into one file. You can then graph EAC (with a little data manipulation), etc.
If you struggle with this, drop me a note, and I will send you an example my e-mail.
Stuart
PS Project 2000 is a serious improvement, and I would strongly advise that you upgrade - not to say the MS Project is my tool of choice. Saving Changes...
