Creating a Budgeted vs Actual Costs Histogram

Learn how to reproduce a common Primavera P6 graph from the Activity Usage Profile - the Budgeted, Actual, Remaining Histogram. Learn how to create this histogram to graph either Costs or Units. You'll also learn how to add cumulative trend lines just like in P6. It's like using the graphs in P6, only much better!

RATS!
This video is only available
to Plan Academy members.

Start Your Primavera P6 Training Today!

Hello, and welcome back! This is Trevor Watt. Today, we’re going to reproduce this chart which is Budgeted, Actual, and Remaining Cost by Date and Cumulative. And we’re also going to reproduce by Units.

So up until now we’ve been grabbing our data from the Resource Module, Resource Assignments Module, but what we’re going to do today is we’re going to grab the data from the Activity Usage Spreadsheet. And using this sheet actually is going to provide you a bunch more options that aren’t available in the Resource Only Spreadsheet.

So as we did before, the first step what we’re going to do is remove our Group and Sort. So go into your Group and Sort settings, delete what’s there and apply. Let’s go in here and go to our columns. I’m going to do here is just remove everything under Activity Name, the stuff we don’t really need. And this collapses this back up. So now we’re on our Activity Spreadsheet we have a bunch more options available. We have Activity Codes, Activity Steps, Earned Value, Financial Period Value, and so far so you can add a bunch of different filters to your graph.

This example we’re going to keep it pretty simple though. I’m just going to select WBS Path and WBS Name, going to apply that. And then I’m going to go in here and touch Spreadsheet Fields. And select the data we actually want to plot. S...

For questions about this course please visit this course's Community Forum.

Course Community Forum