Advanced P6 Reporting in Excel> Graphing Banana Curves
Graphing Banana Curves
Duration: 8m 47s
Skill Level: Beginner
In Lesson 5, you'll learn how to quickly graph a banana curve consisting of Early Units, Late Units and Earned Value. To graph this type of curve, we'll show you how to first extract data from a P6 baseline. Then we'll take Earned Value data from your current project and pull it all together into a useful graph that looks like a banana.
This course will revolutionize how you graph Primavera P6 data! In our Advanced P6 Reporting in Excel course, you’ll learn very specific techniques for quickly exporting Primavera P6 Professional data to Excel, reformatting it and creating amazing-looking graphs and charts with only a few clicks! You’ll also learn to create specialized graphs that are only possible in Excel and not in Primavera P6 Professional natively. This course is a must for any planner who has any sort of reporting responsibilities. This course presents graphing methods in Excel 2013 primarily, but if you're using an earlier version of Excel, don't worry, we'll show you the workarounds.
Video: Graphing Banana Curves
Hello! This is Trevor Watt. Welcome to the next lesson of this Series. Today, we’re going to be discussing Banana Curves.
If you’re not familiar with a Banana Curve is you might want to look it up but I can do a brief explanation here. It is the plot of your Late remaining Labor Units against your Early remaining Labor Units not forms a Banana and in the center here is our Earned Value of Labor Units. Now, Earned Value is typically plotted against the Early Units so the theory is although our earned value is showing us that we’re behind is this is the would be the same as the Planned Value baseline, we could actually potentially finish on time as long as we remain ahead of our Late Units. So to do Earned Value reporting, you need a baseline. So the baseline for this project is attached below, please go and download it and import it into your system. Don’t attach it to your project yet just import it.
So I’m just going to my projects. I already have the baseline added so I’m going to actually remove it and make two separate projects. And we’re just going to restore it. So I’m going to open that baseline. Now when you’re plotting remaining Early and remaining Late Labor Units you have to go to you Assignments button. So first of all, we’re going to stack our columns. And for this particular exerci...