Project Management Stack Exchange is a question and answer site for project managers. It only takes a minute to sign up.
Sign up to join this community
I would like to create a graph like the one below dynamically in Project. I have done this in the past using Excel, but in those cases it was "easy" since planned and earned value were calculated based on contractual milestone payments on a FFP contract. For my current projects this isn't possible, instead any earned value analysis would be based on percentage of work completed and level of effort contributed by internal resources.
I don't believe it does. MS Project is seriously limited in its functionality. On our EVMS solution, we only load our schedule in project; our dollars are loaded into another tool and even a third tool is used to draw the graphs, called Winsight.
It's pretty easy but you have to do it in a weird way.
Go to Reports - Visual Reports
Select New Template, Excel, Assignment Usage, and click OK.
Your report is now being created in Excel. Switch over to Excel.
Add Time Weekly Calendar to the Row Labels section.
Check Cumulative Work, Actual Work and Baseline Work.
Move Values to the Column Labels box.
Then you have all the data you want to manipulate and create your chart.
