Advanced P6 Reporting in Excel> Understanding Excel Charting Options
Understanding Excel Charting Options
Duration: 3m 12s
Skill Level: Beginner
Learn how to manipulate and chart data using Excel's easy drag and drop interface. Practice creating different charts and learn how to create a graph of Total Budgeted Units by Role. You'll also learn how to easily create a Stacked Histogram by Role. Once you get the hang of Excel's charts, you may never go back.
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: Understanding Excel Charting Options
Hello, and welcome back! This is Trevor Watt. We’re going to continue on with Lesson 2 and in this lesson I’m going to discuss these areas of the Pivot Chart. And what happens when we place different items in different areas. So we’re going to continue on with the chart we made in Lesson 1. If you don’t or didn’t save a copy it is available in the link below.
And we’re going to take this chart and first create this which is Total Budgeted Units per each Role and then we’re going to create this, a Stacked Histogram over Time - all using the same data. So in order to get these two charts we go back to the one we created in Lesson 1. We’re going to have just work with our period data. So we’re going to our Spreadsheet Field here and remove the Cumulative Budgeted Units so we just have our period data. And its key to note that even though we have this filter on here, this item has to be in one of these areas in order for that filter to be active. So if I remove this and slide it back over to where you choose your fields, it’s including everything. So it has to remain in one of these areas for the filter to be active. So in order to go from this to the Total Budgeted Units per each Role all we have to do is remove the Week, move the Spreadsheet Field up to the filter, and move the Role name down t...