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.
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, now our Cumulative Remaining Labor Un...
For questions about this course please visit this course's Community Forum.
Course Community Forum