Advanced P6 Reporting in Excel> Graphing Workarounds for Excel 2010 or earlier
Graphing Workarounds for Excel 2010 or earlier
Duration: 3m 41s
Skill Level: Beginner
Want to create some amazing P6 graphs but you're using Excel 2010 or earlier? Don't worry, here are the workarounds you need to make those pretty pictures and charts!
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 Workarounds for Excel 2010 or earlier
Hello! My name is Trevor Watt. And I want to do a quick tutorial or lesson on how to do a Combo Chart in Excel 2010 and earlier Excel software.
Right now, you’re looking at here is Excel 2013 and I just want to refresh your memory if I go and to change Chart Type here. There’s a Combo selection and it’s easy to set up different access and different types of charts. I’m going to close this. Let’s just go… In order to do this I had to remote desktop into my work computer so we’ll see how this works. I have less than one opened up that we created. And from here we’re going to create a Combo Chart. And this is Excel 2010. So you’re going to Options, Pivot Chart – that’s very similar. And what we’re going to start here is we can either start with a column or a line. As you can see there is no Combo Chart specified in here so I’m just going to start with a Clustered Column. We move this to a new sheet. So both series here are represented as Clustered Columns. Now, if we want to change the series to a Line Chart what we could do is we can right click on the series, change series Chart Type, and change it to a Line. And now, we still only have one access so if we right click on the same series again, and we format the data series now we can move it to the secondary access. So there we ...