Building Gantt Charts in PowerPoint? Think again!

There is no argument out there that most project management systems (Microsoft Project included) come up a bit short when it comes to reporting. It’s no surprise that many desperate project managers turn to PowerPoint as an alternative so that they can create project status reports that people can understand.

Of course, this is a time-consuming and error-prone way to do things, but it’s not always clear exactly how much time this kind of effort wastes, so we’re going to run a quick (?) experiment and see for ourselves. Then we’ll compare those results to the results using OnePager Pro, our MS Project add-in that automates the process of building a Gantt chart in PowerPoint.

We’ll start with a simple Microsoft Project plan, where we want to show a subset of 18 tasks. Oversimplified? Definitely–so expect a real project plan to take even longer.

We’ll start by setting up a PowerPoint slide with 18 rows for each task:

ppt1

Time: 7 mins

Now, we’ll add a time axis to the top so that we’ll have a timeline in the report. I’ll need to calculate the duration of my entire project (15 months) and determine the best way to divide up my slide so that it’s readable:

ppt2

Time: 8 mins (total 15 mins)

Next up, I’ll want to start drawing the tasks and milestones on the timeline. This is going to take some effort, since my timeline is only broken out by months, even though tasks are scheduled on a daily basis. I’ll flip back and forth between my project plan and PowerPoint to do this step:

ppt3

Time: 21 mins (total 36 mins)

At this point, we’re about half an hour into reporting on a very simple project, and are just beginning to get something that’s palatable. Of course, we’re nowhere near finished yet in terms of building something that’s actually useful. At a bare minimum, I want to show progress for each task, as well as the baseline, so I can make sure we’re holding to the original plan. We’ll start the swivel chair process with Project again to start moving that data over slowly but surely:

ppt4

Time: 16 mins (total 52 mins)

In the picture above, percent complete is yellow, and baselines are black. At this point, I’m getting annoyed at the imprecision of PowerPoint. I’m pretty sure I’ve gotten a few dates wrong, and I know that I can’t distinguish between 45% and 50% progress at all. Needless to say, I now have a status report that shows dates, progress, and baselines. It’s taken just under an hour so far, though I did get lucky in that there weren’t too many progress bars to draw.

What I really need, though is a chart that gives me an understanding of my project’s resourcing, and this translation of the schedule really doesn’t cut it. So, I’m going to go back into PowerPoint, create some swimlanes, and manually drag each task into the correct swimlanes based on the assigned resources:

ppt5

Time: 12 mins (total 64 mins)

I now have swimlanes, which give me a reasonable grouping of my tasks by resources. Somewhere, somehow, I misplaced one of the progress bars from my original schedule as I was dragging things around, so there is now a rogue yellow line on my chart. I’ll have to go back and determine where it actually belongs.

Meanwhile, I am going to color-code my project by phase so it’s clear which phase each task belongs to. Again, this is pretty tedious and error-prone, because I have to go line-by-line through the project plan and determine which color each task should be. I also have to put together a legend or a key at the bottom of the chart so that it’s clear what each color means. This example project only has four phases, so it’s easier to color-code than most, but still took some time:

ppt_color_code

Time: 17 mins (total 81 mins)

We’ll stop the torture here. After 81 minutes, we have a reasonable-looking chart. But, if you need to create a different view of your project plan (e.g. more detailed), or if you need to make updates to your chart because some of the dates or resources in your plan have changed, you’re looking at a complete tear-down and rebuild. This is why the average project manager spends 4-6 hours each week building and maintaining project reports. Think of what else you could do with that time!

OnePager Pro is designed as a fit-for-purpose tool so that busy PMs can generate meaningful project reports without spending all day doing it. Here’s the same project plan build dynamically in OnePager Pro:

onepager_pro_vs_powerpoint

Time check? Three minutes, thirty-eight seconds (3:38). Not bad, especially compared to 81 minutes in PowerPoint! And, when I update my plan, I can refresh this chart almost instantaneously, which saves me hours on a recurring basis. More complicated projects will take longer, of course, but the time savings factor should be about the same.

So, the next time you want to get back to your real job of successfully delivering projects instead of moonlighting as a graphic artist, give OnePager Pro a spin. Or, just create your charts in OnePager Pro and take the rest of the afternoon off. We won’t tell!

Download a 15-day free trial of OnePager Pro

This entry was posted in Gantt Art, Project Reporting, Project Visualization and tagged , , by Safford. Bookmark the permalink.

About Safford

Safford is a versatile technology professional with a solid history of empowering emerging growth companies in a broad array of industries. His employment history includes energy industry consulting at Quorum Software, Senior Manager of Client Services and Technical Sales at telecom service aggregator GetConnected, and Vice President of Strategic Partner Management at electronic payment processor IP Commerce. Prior to his tenure as OnePager's COO, Safford was the company's Vice President of Marketing and Alliances. Safford holds a BA in Psychology and management from Rice University.

Leave a Reply

Your email address will not be published. Required fields are marked *