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!
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 go, same chart created in 2010.
I...
For questions about this course please visit this course's Community Forum.
Course Community Forum