Advanced P6 Reporting in Excel> Tips & Tricks to Plotting Data in Excel
Tips & Tricks to Plotting Data in Excel
Duration: 11m 01s
Skill Level: Beginner
Cumulative graph lines don't originate at 0. Adding Data Tables below your graphs. How to plot FTEs or format the graph for total man-power. Making multiple charts from the same data. Working with calculated fields in Excel. Adding Chart Titles.
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: Tips & Tricks to Plotting Data in Excel
Hello! This is Trevor Watt. In this lesson I want to discuss some tips and tricks I’ve learned while using this approach to plot your data in Excel. We’re going to continue on with the Spreadsheet we built in Lesson 3. If you didn’t save a copy, there’s a one available for download below. I renamed the sheets just to make it easier to navigate.
So the first item I want to discuss was this Cumulative Remaining Labor Units. It doesn’t originate at 0 so what happens when you dump your data from P6 into Excel. Let’s just go over to the P6 tab. Set a filter on here and let’s go to Cumulative Remaining Labor Units, just filter for that. So as you can see the data doesn’t start from 0. P6 plots a blank cell if there is no data available. Let’s remove this filter. So if we need the zero items, the easiest ways to do that is to select the first blank cell hit Ctrl G, hit Special, select blanks, it will be all highlighted, enter 0, and hold down Ctrl and press Enter. And then all the blanks will be filled with a 0 value so now if we redo our reshaping of our data. I’m just going to select the data and copy it into the old Tableau sheet so I don’t have to recreate the chart. And then go to my Pivot and refresh it so as you can see now 0 has been added to these two lines. So if we go into our chart, ...